How to avoid BLANKS / errors in CHARTS

Prerequisite 

Able to use/create charts in Excel. Know how to use "ISERROR" formula. Please refer to Microsoft help for Syntax.

Possible Usage

To reflect a clean and accurate in formation in charts.

For example, refer to the table below.

If we plot Reject Percentage Vs Date we will get,

First the chart is not accurate as there was no production in certain days and reject rate cannot be considered "Zero".

Second the chart is not tidy. 

The steps (How to do)

1. type =IF(ISERROR(C2/B2)=TRUE,#N/A,C2/B2) in D2

2. Drag or Copy/Paste all the necessary cells

3. We will get a clean and accurate chart

DONE