Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Swapping axes (1)

    If you have a chart with two 'y' axes, does anyone know how you can swap them over so the data in the chart looks the same but the axes labels appear on the opposite y axes (see attached file)?

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swapping axes (1)

    Please attach file.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

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

    Re: Swapping axes (1)

    I'd suspect all you can do is rightclick the series, choose format, Axis tab, and switch the primairy and secondairy axis setting of both series.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swapping axes (1)

    Hopefully attached this time.
    Attached Files Attached Files

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

    Re: Swapping axes (1)

    In addition to Jan Karel Pieterse's reply: you'll have to change the scale properties of both axes after swapping them the way he described. Since these properties are set to manual, they will still have the original values. See attached spreadsheet.
    Attached Files Attached Files

  6. #6
    New Lounger
    Join Date
    Aug 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Swapping axes (1)

    Problem solved, thank you!

Posting Permissions

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