Plotting on an Secondary Axis

ronni_e

New Member
Joined
Jan 13, 2005
Messages
17
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?
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

ronni_e

New Member
Joined
Jan 13, 2005
Messages
17
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.
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

New Member
Joined
Jan 13, 2005
Messages
17
That worked like a charm Jon. Thanks a ton. I had just overlooked that
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,652
Messages
5,597,373
Members
414,139
Latest member
okela0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top