I am using Excel 2007 and am working with a bar graph. I have actual data
from Jan. ’06 though Sep ’08. I would like to modify the graph to
automatically pick up new months when I add data. Now, each month I edit the
data formula to pick up the new month.

I tried extending my data range from Oct ’08 to Dec ’09, even though there
is no data yet. The graph showed the 15 months without data which is not
what I want.

Is there a way to make the graph only display the bar if there is data in
the data range (not blank)?

Thanks,
John M

Take out the extra data
Select the rest and use Inset | Tables | Table, to make the data an Excel
Table
Now the chart will automatically update whenever you add new data to the
Table
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John M" <(E-Mail Removed)> wrote in message
news:C5A4716B-6D7C-476F-B0E9-(E-Mail Removed)...
>I am using Excel 2007 and am working with a bar graph. I have actual data
> from Jan. '06 though Sep '08. I would like to modify the graph to
> automatically pick up new months when I add data. Now, each month I edit
> the
> data formula to pick up the new month.
>
> I tried extending my data range from Oct '08 to Dec '09, even though there
> is no data yet. The graph showed the 15 months without data which is not
> what I want.
>
> Is there a way to make the graph only display the bar if there is data in
> the data range (not blank)?
>
> Thanks,
> John M
>