Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
"moving average" Excel 2003 vs Excel 2007
139 views
Skip to first unread message
LvB38
Dec 16, 2007, 10:55:00 PM12/16/07
to
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?
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?
Mike Middleton
Dec 17, 2007, 1:36:33 AM12/17/07
to
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" <Lv...@discussions.microsoft.com> wrote in message
news:2EF2D2A7-3781-442E...@microsoft.com...
0 new messages