Don't want to plot zero values

[Kristin]

Hi,
I've got a chart showing totals and each month end there
is a new total -- but I don't want it to show all the
zeros in the meantime -- how do i make my chart not show
the zero values?
TIA

Kristin

 

[Frank Kabel]

Hi
one way: replace the zeros with
=NA()

 

[Debra Dalgleish]

Jon Peltier has instructions for creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

You might be able to use one of the techniques for your chart.