Trend line trouble.......

R

Rob Murphy

Hi there. I have a chronological dataset of approximately 30+ points on
excel, graphed up. I would like to add a linear trend line to this dataset,
but only based on the last 10 points (rolling as I add new data). Basically,
I want to retain 30+ weeks of data on the graph, but only want to see the
trend of the last 10 weeks.....

Tricky one?

Many thanks

Rob
 
J

Jim Cone

Rob,
It has been a while since I last did this...
Add a second (duplicate) series, make it invisible, add the trend line to the new series.
If I remember correctly all of the point values should be zero except for the
last ten points. Tell the chart to not plot zeros.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Rob Murphy" <Rob (e-mail address removed)>
wrote in message
Hi there. I have a chronological dataset of approximately 30+ points on
excel, graphed up. I would like to add a linear trend line to this dataset,
but only based on the last 10 points (rolling as I add new data). Basically,
I want to retain 30+ weeks of data on the graph, but only want to see the
trend of the last 10 weeks.....
Tricky one?
Many thanks
Rob
 
R

Rob Murphy

Hi Jim

You're right, it can be done this way. To be honest I was being a bit lazy
and hoping there was someway I could 'modify' the trend line to always
automatically pick up the last 10 points. The reason I'm being a bit lazy is
tis is part of my companies whole KPI reporting and there are about 90 graphs
(a bit crazy I know!!!).

If there isn't a 'funky' way of modifying the trendline itself, I'll crack
on with this solution.

Thanks for your help

Rob
 
R

Rob Murphy

OK, thanks very much...........perhaps in the next version of Excel......

Regards

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top