one trendline from two row ranges

[alldreams]

Hi MVPs,

A1:IV1 keep day's high and A2:IV2 keeps day's low. How
may I have one trend line using these two rows?

Thanks for your help

 

[Jon Peltier]

Dreamer -

Are the two rows plotted as two different series? (What do you do for
the next column? I like to set up my series in worksheet columns.)

You could use a third range, say row 3, that averages High and Low, plot
this on the chart using no lines and no markers, so it's hidden, and use
this series to get a trendline.

- Jon