Stopping Charts Displaying Zero Results

[Guest]

I am building a set of templates to automate building charts and reporting
information. Is there a way to keep Excel charts from displaying a zero
value for future information, i.e. actual usage in March 2005, while
retaining the appropriate cell reference?

 

[Guest]

SCW,

Try one of these "fixes":

(1) Enter the formula "=NA()" for those cells that have zero values. The
X-Axes labels will be displayed but the series will not.
(2) Click on your chart and in the standard toolbar go to Tools -> Options
-> Chart -> "Plot empty cells as" option.

 

[Guest]

I can't enter the "=NA()" formula into the cell because I already have a
formula to link to the master spreadsheet once we have entered an actual
figure spent. I tried plotting the empty cells as "not plotted (leave gaps)"
and it still insists on plotting a zero value on the chart. I'm trying to
make this report automatic, once we fill in the base data.

Thanks,

SCW

 

[Guest]

SCW,

If you already have formulas linking the master spreadsheet, would modifying
them with an IF statement to read something like this work:

=IF(SUM(A1:B1)<>0,SUM(A1:B1),NA())

 

[Guest]

Thank you John. I think I'm brain dead today. It didn't even occur to me to
do an "if" statement.

SCW