Need Help Adding Line to Bar Graph

[jcstoddard]

Hi,

I’m working on a bar graph with 2 series of comparable data – firs
series is YTD @ Current Month, second series is Current Month. I woul
like to add 2 lines to show the system (or overall) average of bot
series. (x-axis=co region; y-axis= score)

How do I do this? I do not want a trending line. I just want
straight line to show overall average. Right now, I’m just drawing
line on the chart but I would like something that will adjust t
updated data. Any help is greatly appreciated

 

[Debra Dalgleish]

Jon Peltier has instructions for adding lines to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine

 

[Jon Peltier]

There are a few techniques described here:

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

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