Limit line on excel graph

This is a discussion on Limit line on excel graph within the Excel Questions forums, part of the Question Forums category; Hi, I have produced a bar chart in excel, and not i need to put a limit line, so i ...

1. Limit line on excel graph

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

2. Re: Limit line on excel graph

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

3. Re: Limit line on excel graph

hi thanks for that,

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

Thank

4. Limit line on excel graph pt 2

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

5. Re: Limit line on excel graph pt 2

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.

6. Re: Limit line on excel graph

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

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•