Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
dj dj is offline
external usenet poster
 
Posts: 92
Default Adding an average line to a chart

Hot a chart with numerous columns (using the 3D standard one); want to add a
moving average line of the data in the graph. How can I do this - do I need
to change the chart type?
--
DJ
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Adding an average line to a chart

You can't do this with a 3D type chart, but that's okay, because you
shouldn't use a 3D chart anyway. They distort and even misrepresent the
data, and people misread and misinterpret them all the time.

Here's how to add such a line to a regular column chart:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"DJ" wrote in message
...
Hot a chart with numerous columns (using the 3D standard one); want to add
a
moving average line of the data in the graph. How can I do this - do I
need
to change the chart type?
--
DJ



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding an average line Gaijintendo Charts and Charting in Excel 2 September 26th 08 08:35 AM
Adding Industry Average Line RJB Charts and Charting in Excel 2 September 15th 08 09:48 AM
adding a line to show average for a data series on a chart Judy Rose Charts and Charting in Excel 1 August 22nd 08 10:01 PM
Adding an Average line (from data sheet) to a chart automatically. Judi Charts and Charting in Excel 5 January 4th 07 01:31 PM
Adding an average line to a bar chart tylercoats Excel Discussion (Misc queries) 2 February 15th 06 02:39 PM


All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"