Simple Plotting Question

[Xenoun]

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

 

[Xenoun]

The MIN/MAX functions don't seem to be working for me. The data for the graph is on another sheet in the workbook and when I enter =MIN(sheetx! etc..) It comes back with function not valid. However if I do this outside of the graph axis reference it works fine.

 

[tusharm]

You use the MIN and MAX functions in the cells where you have the x values for the 2nd series. They do *not* go anywhere in the graph.

The MIN/MAX functions don't seem to be working for me. The data for the graph is on another sheet in the workbook and when I enter =MIN(sheetx! etc..) It comes back with function not valid. However if I do this outside of the graph axis reference it works fine.