How to Add Horizontal Line to Scatter Plot??

[Barklie]

Hello, I have a scatter plot and would like to add a vertical line with a value of 270 to it. Is there a way I can do this? Here is what it looks like so far.

[/URL][/IMG]

Thanks!

 

[Jon Peltier]

A line on a scatter chart is defined by {X1,Y1} and {X2,Y2}.

Put your min and max X in two cells, for example E2 and E3, and put the desired Y value for the line in both F2 and F3.

Right click on the chart, choose Select Data from the pop up menu. Choose Add above the list of series, then select the added series and choose Edit. Type a name in the first box ("Average" perhaps), click in the second box and select the range for the X values (E2:E3 using my sample cells), and click in the third box and select the range for the Y values (F2:F3).

Click OK.

Then select the added series, and format it so it shows a line and no markers.

 

[soolecain]

Very helpful thanks Jon