• Display Right axis on stacked bar chart (EXCEL XP)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Display Right axis on stacked bar chart (EXCEL XP)

    Author
    Topic
    Jimmyc5559
    AskWoody Plus
    January 20, 2005 at 1:25 pm #414818

    Pls. refer to the attached example. Is there any way both a left and right axis / scale [i.e., duplicate the left axis scale on the right side]. The chart will be embedded in a powerpoint slide and think axis / scale information on both the left and right make the chart more realistic and useful. But I have can’t seem to get a right scale/axis to display. Is this possible in EXCEL when using a stacked bar chart? THANKS.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSpieterse
      AskWoody Lounger
      January 20, 2005 at 1:33 pm #923382

      One way:

      Enter some bogus numbers in the empty column to the right of your data and drag that range onto your chart. Now select that series and hit control-1 and change the axis to secondary axis and adjust the scale to match the other axis. Lastly, remove the numbers from the column. See attached.

      Reply | Quote
      • Jimmyc5559
        AskWoody Plus
        January 20, 2005 at 3:12 pm #923411

        Thanks. This works perfectly…but I am sorry to say that I can’t reproduce your graph with the instructions given so that I can do this with other graphs. I have created the bogus data and dragged same to chart. But thats as far as I get. If I select the series and press control&lower case L nothing happens…I never get to a screen that I can change to a secondary axis…sorry to be dense, but any additional newbie instruction is welcome. THANKS,

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          January 20, 2005 at 4:04 pm #923433

          The keyboard shortcut Jan Karel mentioned was not Ctrl+L but Ctrl+1 (the number one).

          Reply | Quote
        • WSpieterse
          AskWoody Lounger
          January 20, 2005 at 4:58 pm #923447

          And this is the dialog you should be seeing after control-1 (and after changing the axis to secondary axis)

          Reply | Quote
          • Jimmyc5559
            AskWoody Plus
            January 20, 2005 at 6:05 pm #923462

            Thank you! I can now re-produce the graph that you did for me originally…again, thanks for not only for solving my problem, but helping me understand the approach so that I can use it again in the future. Take care.

            Reply | Quote
    Viewing 0 reply threads
    Reply To: Display Right axis on stacked bar chart (EXCEL XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.