two y-axes, three variables

[lenka pdx]

I have four columns of data:
Column A is essentially the X-axis.

Column B and C are numbers that fall within the same range

Column D is another set of numbers that is not within the range of B and C.

Is is possible to make a graph that would have a primary and a secondary y-axis, then plot the numbers in columns B and C using the primary y-axis and column D using the secondary y-axis?

I can't figure out how to tell Excel which y axis goes with which variable. I know how to do it with two, but not with three.

Thanks!

 

[Mark W.]

Yes, right-click the series that you want on the secondary y-axis, choose Format Data Series... from the popup menu, and pick the Secondary axis radio button on the Axis tab.