View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
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