How to make a 3 axis graph in excel

Thanks:  0
Likes:  0

# Thread: How to make a 3 axis graph in excel

1. ## How to make a 3 axis graph in excel

HI,
I need to make a graph that has 1 y axis on the left and two y axes on the left. Any suggestions?

2. ## Re: How to make a 3 axis graph in excel

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.

3. ## Re: How to make a 3 axis graph in excel

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?

4. ## Re: How to make a 3 axis graph in excel

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.

5. ## Re: How to make a 3 axis graph in excel

Thanks! That works!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•