Showing only the last x entries

[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

 

[Frank Kabel]

Hi
have a look at
http://www.tushar-mehta.com/excel/software/autochart/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

 

[Talib]

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

Thanks Tali

 

[Frank Kabel]

Hi
depends how you calculate your moving average

 

[Tushar Mehta]

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