Showing only the last x entries

  • Thread starter Thread starter Talib
  • Start date Start date
T

Talib

Hi

I have a chart with a moving average trendline. There are too may dat
entries and the chart is unreadable. I would like the chart to onl
display the last x entries (automatically) but still have the movin
average trendline applied to all the data.

To rephrase the question: I need the graph to be zoomed into the last
data.

Any help would be appreciated

Thanks
Tali
 
With those methods will my moving average trendline be applied to al
the data or only the ones I am currently viewing?

Thanks Tali
 
Why not try it and see?

Or reason through the problem. How many points does the trendline
require? And, where is it? On the chart, correct? OK, so what does
the chart show? Enough points to calculate the trendline as expected?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top