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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
30 Day Moving Average on 30 Day Bar Chart
On Fri, 30 Mar 2007, in microsoft.public.excel.charting,
Charles in Iraq said: 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? The trick is to realise that, alone of all the possible calculations that you can do with your data, trend lines are controlled at the chart. This fools a lot of people into thinking they need to treat Excel as a Chart program with a little cell-based data entry facility. It's not, it's a spreadsheet with a little chart display facility. Make your moving average in your spreadsheet using the AVERAGE() function, and plot the thirty days of that, along with the thirty days of data. Best to put a little text box note on the chart as well, explaining to the reader of the chart what you did. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
30 Day Moving Average on 30 Day Bar Chart
Okay, this sounds like a good idea - have a separate series to
plot the 30 day moving average and compute the values of this series with the AVG function. However, this still leave one problem: how to draw this second series on the chart as a line instead of a bar. Is this possible? Can I format one series on a chart as a bar while I format the other as a line? "Del Cotter" wrote: On Fri, 30 Mar 2007, in microsoft.public.excel.charting, Charles in Iraq said: 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? The trick is to realise that, alone of all the possible calculations that you can do with your data, trend lines are controlled at the chart. This fools a lot of people into thinking they need to treat Excel as a Chart program with a little cell-based data entry facility. It's not, it's a spreadsheet with a little chart display facility. Make your moving average in your spreadsheet using the AVERAGE() function, and plot the thirty days of that, along with the thirty days of data. Best to put a little text box note on the chart as well, explaining to the reader of the chart what you did. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
30 Day Moving Average on 30 Day Bar Chart
Charles,
Once you have your second series set up as bars, you can change the bars to a line by doing the following: Click once on any of the bars that make up the second series. Choose "Chart" from the toolbar. Go to "Chart Type". Choose "line" and hit "OK". -- John "Charles in Iraq" wrote: Okay, this sounds like a good idea - have a separate series to plot the 30 day moving average and compute the values of this series with the AVG function. However, this still leave one problem: how to draw this second series on the chart as a line instead of a bar. Is this possible? Can I format one series on a chart as a bar while I format the other as a line? "Del Cotter" wrote: On Fri, 30 Mar 2007, in microsoft.public.excel.charting, Charles in Iraq said: 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? The trick is to realise that, alone of all the possible calculations that you can do with your data, trend lines are controlled at the chart. This fools a lot of people into thinking they need to treat Excel as a Chart program with a little cell-based data entry facility. It's not, it's a spreadsheet with a little chart display facility. Make your moving average in your spreadsheet using the AVERAGE() function, and plot the thirty days of that, along with the thirty days of data. Best to put a little text box note on the chart as well, explaining to the reader of the chart what you did. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
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 |