Limit line on excel graph

[johnedinburgh]

Hi,

I have produced a bar chart in excel, and not i need to put a limit line, so i can clearly see if the bars are above or below the limit.

Can i do this without rebuilding the chart? and how?

Thanks

[wigi]

You can do so.

Add the values for a (constant) line as a new series.

Then, right click one of the bars for the second series, and change the chart type to a Line, for instance.

Wigi

[johnedinburgh]

hi thanks for that,

can i get a line that stretches across the width of the graph, instead of a small star?

Thank

[johnedinburgh]

i have created a limit line on my bar chart with the help of another board member, however it is just a small line, how can i stretch the line the full way across the graph?

Thanks

[wigi]

How many values do you plot for that line? You could have that (always the same constant) value on each X axis value, just as you do for the bars.

[pgc01]

Hi

To plot a straight line you just need 2 points. Define the points like (Xmin,Y) and (Xmax,Y) where Xmin and Xmax are the maximum and minimum values in the X axis and Y defines the limit value.

If you still have doubts Jon Peltier explains here how to add a horizontal line to a chart:

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