Need Help Adding Line to Bar Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jcstoddard - 29 Sep 2004 21:51 GMT

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

Reply to this Message

Debra Dalgleish - 30 Sep 2004 01:45 GMT

Jon Peltier has instructions for adding lines to a chart:

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

> Hi,
>
[quoted text clipped - 7 lines]
> line on the chart but I would like something that will adjust to
> updated data. Any help is greatly appreciated.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Jon Peltier - 30 Sep 2004 01:59 GMT

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/
_______

> Hi,
>
[quoted text clipped - 7 lines]
> line on the chart but I would like something that will adjust to
> updated data. Any help is greatly appreciated.

Reply to this Message