Swap Y-Axis numbers

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!
 
J

Jon Peltier

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
 
K

kwinston

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
_______
 
S

sorannouri

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!

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top