Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 Y-AXIS BAR CHARTS (Excel '97)

    I am trying to determine if it is possible to have a BAR CHART with 2 displayed and
    labeled Y-Axis. I am trying to show number of events as one bar and % of events in the
    next bar. With large numbers and only one Y axis the Percentance gets swamped
    by numbers.

    For example:

    Frequency Percent
    1000 25
    2000 50
    500 12.5
    500 12.5

    If it is not possible in Excel '97, what about later versions?

    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: 2 Y-AXIS BAR CHARTS (Excel '97)

    If you rightclick one of both series,and choose FOrmat series, you can specify a secondairy axis on the Axis tab.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Y-AXIS BAR CHARTS (Excel '97)

    Although this routine does allow two axis to show, only one data range is plotted, the one that was chosen with right click. Would like to be able to show both data ranges and their associated axis.

    Thanks

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: 2 Y-AXIS BAR CHARTS (Excel '97)

    The first is BEHIND the second. CHange the scale of the percent to a max o 100 and you will see both of them.

    How do you want the chart to look? YOu might be able to set it up differently to get the effect you want.

    Steve

Posting Permissions

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