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
_______
Click to expand...
 

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

Similar Threads

Make Y-axis values correspond to x- axis value 1
Adding a line to a population bar chart 0
how to switch the primary and secondary Y axis to opposite chart s 2
Coordinate secondary y axis to primary y axis 2
reverse axis not working as before... 0
Using the full width of an Excel chart with two Y-axes 2
simple chart 0
Scatter chart with categories on x-Axis 2

Top