Adding a Fixed Horizontal Line

Question

Adding a Fixed Horizontal Line

Anonymous

Hello All,

I am trying to add a fixed horizontal line to a scatter plot that will span the entire chart, regardless of x-axis. For this reason the error bar method will not work. It also needs to be dynamic, as the location is subject to change.

Thanks

Jacob

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Answer 1

Anonymous

This may get you on track

best wishes

0 comments

Answer 2

You can still use a separate data series for the horizontal line. It would only require two data points (x1,y1) (x2,y2) connected with a line. Use formulas for the x and y values. For the y values you can use a formula that is based on the other data. You could use a formula for x1 and x2 that calculates the minimum and maximum of all 3 of the other sets of x values.

Answer 3

Since the horizontal line will be described by data points, there is no reason those datapoints can't be built with a formula so that it is plotted based on the other data being plotted. Unless you want to write macros, I believe this is pretty much you option.

--

Regards,

Tom Ogilvy

Answer 4

Hey Tom

That wouldn't really work here. I have three different sets of data I am trying to plot on a scatter plot, and each set has differing amount of data. So I need something that will have a horizontal line at a point that can be set, and will move with the data no matter which set has the most points.

Thanks

Jacob

Answer 5

Anonymous

add data as a new series that plots a straight line.

--

Regards,

Tom Ogilvy

0 comments

Share via

Adding a Fixed Horizontal Line

5 answers