Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Display Right axis on stacked bar chart (EXCEL XP)

    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.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display Right axis on stacked bar chart (EXCEL XP)

    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.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Display Right axis on stacked bar chart (EXCEL XP)

    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,

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Display Right axis on stacked bar chart (EXCEL XP)

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

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display Right axis on stacked bar chart (EXCEL XP)

    And this is the dialog you should be seeing after control-1 (and after changing the axis to secondary axis)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Display Right axis on stacked bar chart (EXCEL XP)

    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.

Posting Permissions

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