Graph trend line help required (WITH PICTURES!!!!) (1 Viewer)

[Singlespeed]

I have a line chart with 3 years worth of months on the X axis (36 points) and I have a 3 year trend line. what I need is another trend line for the last 12 months, I have added a field in my data with just the last months data points but when I add a trend line to that one it goes right back to the start when I need it just on the last 12 months!

Any ideas how I can fix it?

Ok graph before I add the trend line for the last 12 months data points (orange on the "actual" line)

and this is what happens when I add the trend line!!!!

All I want is a trend line for the most recent 12 months - I am using MS ACCESS 2000 and I have tried to use the SLOPE function (to build a trend line data points in the query) but nothing happening - i can get Access 2003 if you know that will help, please let me know.

SS

 

[panasonic]

Very good information I see there are realy useful tips. I am going to use some i would be glad if u visit my Artikelverzeichnis. but u need understood german
comparatif simulation taux credit auto - Taux crédit auto. Comparatif des offres! Les meilleurs taux crédit auto sont sur le net !comparatif simulation taux credit auto

 

[Singlespeed]

ping - any help - I am still looking for a solution