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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to chart months by financial year 0
2003 Excel Chart with zero data 5
Hide Cells with Zero Value in Excel 2007 while using line chart ty 4
XY chart not dropping off to 0, when there is not value 4
Making a Blank Cell 1
Graph points going to zero 4
Excel 2007 Chart with Zero Values 5
Problem with line Chart 2

Back
Top