Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving average | Excel Worksheet Functions | |||
how to do a 50 day and 200 day moving average | Excel Discussion (Misc queries) | |||
how do i chart a 24 month moving average of sales shipments | Charts and Charting in Excel | |||
Moving average | Charts and Charting in Excel | |||
Plotting moving average line on a chart | Charts and Charting in Excel |