two y-axes, three variables

lenka pdx · Apr 19th, 2002, 02:30 PM

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. · Apr 19th, 2002, 02:42 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 02:30 PM	#1
lenka pdx New Member Join Date: Apr 2002 Posts: 1	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!

Apr 19th, 2002, 02:42 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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.