Hi,
I am trying to make an line/scatter line chart for trend analysis where there are x-axis and y-axis values in two different columns.
In the attached image, I would like to use columns D and I as x-values and E and J as y-values. However, I want the points to display in order of the x axis value. If I simply select each column the trend line will display as the points in column D connected and then a line to the points in column I. What I need is to display D1, followed by I1, followed by D2, I2,D3,I3 and so on, connected by a line in that order.
Is there a named range formula I can use for the x-axis and then use the offset function for the y-axis?
Thank you!
I am trying to make an line/scatter line chart for trend analysis where there are x-axis and y-axis values in two different columns.
In the attached image, I would like to use columns D and I as x-values and E and J as y-values. However, I want the points to display in order of the x axis value. If I simply select each column the trend line will display as the points in column D connected and then a line to the points in column I. What I need is to display D1, followed by I1, followed by D2, I2,D3,I3 and so on, connected by a line in that order.
Is there a named range formula I can use for the x-axis and then use the offset function for the y-axis?
Thank you!
