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" wrote in message
...
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