Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"moving average" Excel 2003 vs Excel 2007
If I run a moving average on data specifying chart output in Excel 2003, the
chart I get is a pair of lines giving "actual" and "forcast" data. If I run the same function in Excel 2007, I get a column chart showing only forcast data. I can't figure out how to get the 2003 chart. Can anyone help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"moving average" Excel 2003 vs Excel 2007
LvB38 -
In Excel 2007 SP1 when you use Data | Data Analysis | Moving Average, Excel does produce only a column chart of the moving average (forecast) values. To fix it in Excel 2007, with the chart active, choose Chart Tools | Design | Change Chart Type | Line | OK. Select the actual data, right-click and choose Copy, select the chart, right-click and choose Paste. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "LvB38" wrote in message ... If I run a moving average on data specifying chart output in Excel 2003, the chart I get is a pair of lines giving "actual" and "forcast" data. If I run the same function in Excel 2007, I get a column chart showing only forcast data. I can't figure out how to get the 2003 chart. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use "Data, Forms" from Excel 2003 in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A" | Excel Worksheet Functions | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
Excel 2007 "Personal Budget" template to 2003? | Excel Discussion (Misc queries) | |||
Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) |