one trendline from two row ranges

  • Thread starter Thread starter alldreams
  • Start date Start date
A

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
 
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
 
Back
Top