Swap Y-Axis numbers

  • Thread starter Thread starter kwinston
  • Start date Start date
K

kwinston

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!
 
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
 
Thank you! That worked perfectly!

Jon Peltier said:
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
_______
Click to expand...
 
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!
Click to expand...

Perfect! Thanks.

Note: if the chart changes as you change the primary/secondary axes, left click on chart and 'change chart type' to change the settings back to what they were. Those were altered for me after changing the primary/secondary axes.
 
Back
Top