How can I not graph a 0 value.

  • Thread starter Thread starter jbd
  • Start date Start date
J

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
 
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
 
jbd said:
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?
Click to expand...

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