Swap Y-Axis numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kwinston - 18 Apr 2008 15:58 GMT

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!

Reply to this Message

Jon Peltier - 18 Apr 2008 17:37 GMT

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
_______

>I have a "Line - Column on 2 Axes" chart that looks exactly like I want it
>to
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

kwinston - 18 Apr 2008 17:53 GMT

Thank you! That worked perfectly!

> 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
[quoted text clipped - 19 lines]
> >
> > Thanks!

Reply to this Message