Make a dynamic chart:
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
If you have XL 2003, make the data a "list" before charting and XL
automatically makes it dynamic
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"meegan" wrote in message
...
I have a chart that i am making of PPMs for the year of 2006. I have
jan-may
in the data series and the rest are left blank. I am trying to get a
trendline in where it will stop at whatever month I am at but update when
a
new month's data is entered into the box. However, I cannot figure out
how
to do this, when I do have a trend line it goes to like -4000. can anyone
help me please?