Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to display 3 scales on one graph

  1. #1
    New Member
    Join Date
    Jan 2009
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to display 3 scales on one graph

    This may be less of an Excel question than a general data display question, but I'll try here.

    I have 3 variables that I'm charting. I have one on the primary axis and it's values are in the billions. I have one on the secondary axis and it's a percentage. I need to display a 3rd who's value is in the millions. If I put it on the primary axis, you cannot see modest changes.

    Is there a tricky way to get all three on one graph? I know I could split on two graphs, so that's my backup plan.

    Thanks,

    Dave

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to display 3 scales on one graph

    Microsoft MVP - Excel

  3. #3
    New Member
    Join Date
    Jan 2009
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to display 3 scales on one graph

    Thank you Andrew. That's very involved to set up, but if I cannot find another way I may look into that.

    Dave

Some videos you may like

User Tag List

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
  •