EXCEL - Charts

[Sandman007]

In creating my charts I have some source data that is equal to zero. Is there a way to only show the data that is non-zero on my charts? I know that Excel won't display points that have no data, but I need it for data that has a value of zero.

 

[tsuji]

Hello, Sandman007.

#N/A cell value features often much better in charting than blank or zero derived from some non-numeric source. Hence, to serve particularly for charting, map 1-1 your source range to another range with #N/A as the image of blank or zero in the source. Then take the destined range as the source for your chart. (An example of its working, take a look of Thread68-164499.) This is the general idea.

regards - tsuji

 

[Hasit]

Have a look at my FAQ, which describes how to ignore zero's in a graph. This may help.

faq68-1277