Use dynamic ranges for the X and Y values of each series:

http://peltiertech.com/Excel/Charts/...umnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"patrick" wrote in message
...
I have a chart that shows 07 months as the x axis labels. My table has
labels
for Jan 07 thru Dec 07. There isn't any data for Aug 07 thru Dec 07. Can I
make the chart not show those labels. Then when someone adds the data for
those months it automatically updates the chart...ie add the labels for
the
following months as they are inputted?