Results 1 to 5 of 5

How to make a 3 axis graph in excel

This is a discussion on How to make a 3 axis graph in excel within the Excel Questions forums, part of the Question Forums category; HI, I need to make a graph that has 1 y axis on the left and two y axes on ...

  1. #1
    New Member
    Join Date
    Jun 2008
    Posts
    5

    Default 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. #2
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    15,713

    Default 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.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  3. #3
    New Member
    Join Date
    Jun 2008
    Posts
    5

    Default 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. #4
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    15,713

    Default 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.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  5. #5
    New Member
    Join Date
    Jun 2008
    Posts
    5

    Default Re: How to make a 3 axis graph in excel

    Thanks! That works!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com