LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Trend line trouble.......

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you extend the trend line? kim tt Excel Discussion (Misc queries) 1 December 8th 06 02:32 PM
Which trend line? joyous_h New Users to Excel 1 July 25th 06 01:32 PM
Trend line AndreasN Charts and Charting in Excel 2 February 12th 05 07:37 PM
trend line does not appear JB Charts and Charting in Excel 1 January 26th 05 08:24 PM
trend line Nee Charts and Charting in Excel 2 January 25th 05 03:11 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"