drop zero lines from charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a automated chart I create every month. Sometimes there is no data for
that month. I'd like the chart to still show that month without the line
dropping to zero.

I have the data below the chart coming over as blank by formatting the cell
to "number" and setting it at "0;-0;;". I was hoping that there is an easy
way to have the line in the chart drop off also when there is no data to come
over.

Thanks in advance
 
Hi,

With the chart selected choose Tools, Options, Chart, and chose Plot empty
cells as Not plotted.
 
Thanks for the response. I went into the chart section, but, the area for the
"Plot empty cells" and it was grayed out. Maybe it's a newer version that
offers that option? Any ideas?
 
Hi,

Did you have the chart selected when going to options, as Shane stated?

Is it a protection problem?

Cheers
Andy
 
Back
Top