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.
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
DONE
2. Drag or Copy/Paste all the necessary cells
3. We will get a clean and accurate chart
DONE
ExpiresDefault access plus 1 year
It usefull for me, but I still workvwith excel 2003
ReplyDeleteEnsure all data is properly HostMyCode formatted, complete, and sourced from reliable inputs before creating charts to avoid blanks and errors.
ReplyDelete