horizontal line on column chart

[Kierrica]

How would I go about placing a horizontal line at a certain value across a column chart?
This message was edited by Kierrica on 2002-08-26 16:05

 

[PaddyD]

see:

http://www.geocities.com/jonpeltier/Excel/Charts/index.html#ColChtHorizLine

for how to insert a horizontal line in a chart

paddy

 

[Legacy 98055]

Hi Kierrica, Paddy.
That's a great site Paddy. Another approach which I use to show a "goal" so to speak is to simply draw out a line. Of course, this assumes that you will not need the line's position to change.

Tom

 

[zacemmel]

Just create another data series and change that series to be a line instead of whatever the rest of the chart is. You can do this by right click on the data series and selecting "chart type."