View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Charles in Iraq Charles in Iraq is offline
external usenet poster
 
Posts: 13
Default 30 Day Moving Average on 30 Day Bar Chart

Greetings:

I want to add a 30 day moving average trendline to my
30 day bar chart. The problem is that to correctly com-
pute the moving average for all 30 days, I need to use
the last 60 days of data even though I only want to plot
the last 30 days on the chart.

How can I use the last 60 days of data to compute this
trendline while only plotting the last 30 days as bars on
the chart?

Respectfully,

Charles