Adding an average line to a chart

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Access Combination Chart Types Access 2010 0
How can I combine a stacked column chart and line chart? 1
Show average line by series on a line chart 1
adding a line to show average for a data series on a chart 1
Adding a line to a bar chart 1
How to chart months by financial year 0
Aligning an excel table w/ a cluster column chart x-axis columns 2

Back
Top