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