You could make a dynamic chart that plots an expanding range:

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

If you want to include the full year on the axis, don't make a dynamic range
for X values, only for Y values.

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


"Dom" wrote in message
...
Hi

I am creating a graph to show information from this year I currently have
it
set up so the graph shows jan-dec one line for 2007 and one line for 2008
the
information automatically populates itself into the chart so currently for
April 2008 to December 2008 the information is showing as zero and so
there
is a big line that goes across zero on my graph. Is there anyway for the
graph to ignore the 0's? and only show any numbers above this?

Thank you