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

--
Baltimore Ravens

Hi,

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


"Ravens Fan" wrote:

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

--
Baltimore Ravens

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?
--
Baltimore Ravens


"ShaneDevenshire" wrote:

Hi,

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


"Ravens Fan" wrote:

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

--
Baltimore Ravens

Hi,

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

Is it a protection problem?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ravens Fan" wrote in message
...
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?
--
Baltimore Ravens


"ShaneDevenshire" wrote:

Hi,

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


"Ravens Fan" wrote:

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

--
Baltimore Ravens