How do I create different scales on Excel charts?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris H - 31 Oct 2006 13:29 GMT

I want to create two different scales in metric and imperial. Is this possible

Reply to this Message

Jon Peltier - 31 Oct 2006 13:46 GMT

You can do this using primary and secondary axes. In order to get a
secondary axis, you need a second series. It can be a dummy series formatted
to be hidden. Before hiding it, however, double click on it, and on the Axis
tab of the dialog select Secondary.

Format the secondary axis as desired, and calculate the maximum scale value
you need so that the axes properly line up. This will not occur
automatically in Excel. You either need to do it manually or through use of
a macro.

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

>I want to create two different scales in metric and imperial. Is this
>possible

Reply to this Message

Chris H - 31 Oct 2006 15:47 GMT

Thank you. I have now got this for the Y axis how can I do the same for the
X axis?

Chris H

> You can do this using primary and secondary axes. In order to get a
> secondary axis, you need a second series. It can be a dummy series formatted
[quoted text clipped - 15 lines]
> >I want to create two different scales in metric and imperial. Is this
> >possible

Reply to this Message

Jon Peltier - 31 Oct 2006 17:04 GMT

Make sure it's an XY chart. If you have a secondary Y axis, go to Chart menu

> Chart Options > Axes tab, and check the option for a secondary X axis.

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

> Thank you. I have now got this for the Y axis how can I do the same for
> the
[quoted text clipped - 25 lines]
>> >I want to create two different scales in metric and imperial. Is this
>> >possible

Reply to this Message