Bar Chart
 

how do I show an "Average" line (moving R to L) on a Bar Chart?
I have figured otu how to do a moving average, but that's not what I need.
I just want a line going accross the page, from left to right, showing an
average of all the bars (in this case 75%).

Bar Chart
 

Try using a helper column with the average in it and then format the bar to a
line.

eg if your data is in cells B1:B5 then in cells C1:C5 have
=AVERAGE($b$1:$b$5) and plot both
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"cv" wrote:

how do I show an "Average" line (moving R to L) on a Bar Chart?
I have figured otu how to do a moving average, but that's not what I need.
I just want a line going accross the page, from left to right, showing an
average of all the bars (in this case 75%).

Bar Chart
 

Try one of these:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"cv" wrote in message
...
how do I show an "Average" line (moving R to L) on a Bar Chart?
I have figured otu how to do a moving average, but that's not what I need.
I just want a line going accross the page, from left to right, showing an
average of all the bars (in this case 75%).