Swap Y-Axis numbers
 

I have a "Line - Column on 2 Axes" chart that looks exactly like I want it to
except I want to swap the Y-Axes but leave the chart as is. Is this possible?

The primary Y-axis corresponds to the bar charts and is located on the left
side of the chart. The secondary Y-axis corresponds to the lines and is
located on the right side of the chart. I want to simply show the Primary
axis numbers on the right and the secondary axis numbers on the left.

Thanks!

Swap Y-Axis numbers
 

Change the Line series so it's plotted on the primary axis (double click the
series, click on the Axes tab, select primary). Then change the column
series so it's plotted on the secondary axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"kwinston" wrote in message
...
I have a "Line - Column on 2 Axes" chart that looks exactly like I want it
to
except I want to swap the Y-Axes but leave the chart as is. Is this
possible?

The primary Y-axis corresponds to the bar charts and is located on the
left
side of the chart. The secondary Y-axis corresponds to the lines and is
located on the right side of the chart. I want to simply show the Primary
axis numbers on the right and the secondary axis numbers on the left.

Thanks!

Swap Y-Axis numbers
 

Thank you! That worked perfectly!

"Jon Peltier" wrote:

Change the Line series so it's plotted on the primary axis (double click the
series, click on the Axes tab, select primary). Then change the column
series so it's plotted on the secondary axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"kwinston" wrote in message
...
I have a "Line - Column on 2 Axes" chart that looks exactly like I want it
to
except I want to swap the Y-Axes but leave the chart as is. Is this
possible?

The primary Y-axis corresponds to the bar charts and is located on the
left
side of the chart. The secondary Y-axis corresponds to the lines and is
located on the right side of the chart. I want to simply show the Primary
axis numbers on the right and the secondary axis numbers on the left.

Thanks!