How to Prevent Blank Cells from plotting in Excel Charts?

[Ashish Jain]

Hi Friends,

Read this, if you want to avoid plotting of blank cells as zeroes.
http://www.excelitems.com/2011/01/prevent-blank-cells-plot-chart.html

Esp. go through the comment of Jon Peltier who has provided great insight to it.



Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com