drop zero lines from charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ravens Fan - 26 Sep 2007 17:08 GMT

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

Signature

Baltimore Ravens

Reply to this Message

ShaneDevenshire - 26 Sep 2007 20:29 GMT

Hi,

With the chart selected choose Tools, Options, Chart, and chose Plot empty
cells as Not plotted.

Signature

Cheers,
Shane Devenshire

> 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
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message

Ravens Fan - 27 Sep 2007 11:17 GMT

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?

Signature

Baltimore Ravens

> Hi,
>
[quoted text clipped - 11 lines]
> >
> > Thanks in advance

Reply to this Message

Andy Pope - 27 Sep 2007 11:38 GMT

Hi,

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

Is it a protection problem?

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

> Thanks for the response. I went into the chart section, but, the area for
> the
[quoted text clipped - 22 lines]
>> >
>> > Thanks in advance

Reply to this Message