Re: Ignore Plotting Zeros Or Empty Cells As Zero In Chart
Quote from AAE
Try using =NA() instead of =""
If having #N/A in the cell is objectionable, use conditional formatting to hide it.
You could also hide the columns or rows that are empty.
Many thanks for your reply. I can't hide the rows that are empty because the chart is only one part of the sheet and it would effect too much. But, I like the #N/A solution. Here is what works, so far (with little check so far)
=IF(Custom_Chart_Variable=Custom1_Header,IF('2009 Log'!AD348="",NA(),'2009 Log'!AD348),IF(Custom_Chart_Variable=Custom2_Header,IF('2009 Log'!AE348="",NA(),'2009 Log'!AE348),IF(Custom_Chart_Variable=Custom3_Header,IF('2009 Log'!AF348="",NA(),'2009 Log'!AF348),IF(Custom_Chart_Variable=Custom4_Header,IF('2009 Log'!AG348="",NA(),'2009 Log'!AG348),""))))
Seems funny Excel doesn't have an ignore zeros solution built in. I thought previous version of Excel had this. I might be wrong, though.