Hello,

I've a weekly chart that shows the weekly candlestick chart for the fund
prices and a 39-week moving average line.

Now, I have so much data that I only want to plot around 2 years' data on
the chart. If I select this range only and let Excel create the moving
average line, the moving average line will only start at 39 weeks into this
2-year period. However, I want this line to start from the start of this
2-year period.

Any way to do this?

Thanks.

Herbert