Thread: trendline HELP!

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?

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" <meegan@discussions.microsoft.com> wrote in message
news:7C0764A9-933B-44BB-8FB1-61B4FDB43353@microsoft.com...
>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?