Plotting on an Secondary Axis

[ronni_e]

I am doing an XY Scatter plot and need to include a secondary X and Y axis. Basically I added an extra point and told it to be on the secondary axis. Its only adding the secondary Y axis though rather than the X axis as well. How do I add both the secondary X and Y Axis?

 

[Anne Troy]

I have never heard of a secondary X axis.

 

[ronni_e]

Hum.. Our teacher told us to plot all of our values in SI units. The experiment was done in English. Like you ive not heard of a secondary X axis. I guess the only other option would be to include 2 plots..

Ill have to ask him.

 

[Anne Troy]

I dunno what SI units are, but I think I'd ask him. Good luck!

 

[Jon Peltier]

When you assign a series to the secondary axis, Excel usually only creates a secondary value (Y) axis. To get a secondary category (X) axis (really not all that uncommon), choose Chart Options from the Chart menu, click on the Axes tab, and check the combination of axes you want (or don't want).

Annie: SI means metric units (from the French "Système International d'Unités").

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

 

[ronni_e]

That worked like a charm Jon. Thanks a ton. I had just overlooked that

 

[Jon Peltier]

Some of these things are hidden where it's hard to find. There should be more of an affort to inform users where they are. Secondary axes, secondary X axes, custom combination charts, etc.

This keeps forums like Mr Excel busy.

- Jon