How can I not graph a 0 value.

[jbd]

I have a graph that is charting monthly sales over an 8 year period.
have my chart set to automatically update as the future data i
entered. My problem is that I want my y axis to show all 8 years an
my graph line to stop at the current month and not graph the zer
values for the future months. Does anyone know how I can do this

 

[erin_taylor]

Go to Tools>Options, Click on the Charts tab and choose the "not plotted
option"

 

[jbd]

Thanks. I tried the "do not plot" and it worked great if my cells wer
empty, however, the cells that my source data covers are formulas an
the graph is reading the formulated cells as 0 and charting it. An
suggestions on how I can make my formulas appear to be empty so m
graph won't chart it

 

[David Biddulph]

Thanks. I tried the "do not plot" and it worked great if my cells were
empty, however, the cells that my source data covers are formulas and
the graph is reading the formulated cells as 0 and charting it. Any
suggestions on how I can make my formulas appear to be empty so my
graph won't chart it?

Try to get the formula to return NA(), rather than zero or a blank.