View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Murphy Rob Murphy is offline
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