How to make a 3 axis graph in excel

karilynne

New Member
Joined
Jun 19, 2008
Messages
5
HI,
I need to make a graph that has 1 y axis on the left and two y axes on the left. Any suggestions?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Hi karilynne
Welcome to the board

My suggestion is that you don't do it.

As far as I know all chart specialists agree that it's a bad and confusing solution. Some even argue that even 2 axes should be avoided.

There are better alternative solutions.

Check this Jon Peltier page, read these articles:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Notice that Jon had a page where he explained how to implement the terciary axis but removed it, for the reasons above.
 
Upvote 0
HI,
I know that a 3 axis graph is not optimal, but I need to recreate a graph that was made in Origin. It is what the researcher would like. Any suggestions?
 
Upvote 0
In that case, since the third axis is not supported directly by excel, you'll have to create it yourself.


I've not done for years and I don't have any example at hand. I can give some hints

- the third axis will be, in fact, just a vertical line drawn by you

- you format that line like an axis, formatting the color of the line and of the marker, the width of the line and the type of the marker

- you change the labels of that line to the values you want in your axis

- the series you use for the third axis is not the original series but the original series multiplied by a scale factor

These are the main ideas.


To clarify, let's suppose that the series have these ranges

Series 1: 0 to 10
Series 2: 200 to 450
Series 3: 10000 to 20000

- choose for example series 1 and 3, build the chart and send series 3 to the secondary axis.

- build a table for the series 2 auxilliary, that will have all the values of the original series divided by 50. This means that its values will have a range 4 to 9, ok for the primary axis.

- add this aux series to the chart, in the primary axis

The 3 series are now all on the chart and thanks to the scaling we did, the second series does not disrupt the first axis


You can now add the new axis with the appropriate labels to series 2 aux.

This is not difficult, but requires some work. If you are not used to manipulating the chart please post more specific doubts, the series chart types, maybe an example of your data and more details. In that case don't forget to add your excel version.

Hope it's clear.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

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
Back
Top