Hello,

I'm just wondering if its able to plot a horizontal line on a graph at a specific value. i.e. y=4. I'm currently just plotting two points and letting the graph add the line between them, but it would be much more useful if excel had a way of automatically plotting a horizontal line at a spicified point.

Does this exist, or am I just wishing for something that isn't there? I'm using Excel 2007 if that helps

Thanks

Edit: I'm using a scatterplot aswell, didn't state it earlier

I'm just wondering if its able to plot a horizontal line on a graph at a specific value. i.e. y=4. I'm currently just plotting two points and letting the graph add the line between them, but it would be much more useful if excel had a way of automatically plotting a horizontal line at a spicified point.

Does this exist, or am I just wishing for something that isn't there? I'm using Excel 2007 if that helps

Thanks

Edit: I'm using a scatterplot aswell, didn't state it earlier

Last edited: