• Swapping axes (1)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Swapping axes (1)

    Author
    Topic
    WSpinsar
    AskWoody Lounger
    August 14, 2002 at 11:37 am #374970

    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)?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSreimer
      AskWoody Lounger
      August 14, 2002 at 12:13 pm #608414

      Please attach file.

      Chuck

      Reply | Quote
      • WSpinsar
        AskWoody Lounger
        August 14, 2002 at 12:21 pm #608417

        Hopefully attached this time.

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          August 14, 2002 at 12:35 pm #608421

          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.

          Reply | Quote
    • WSpieterse
      AskWoody Lounger
      August 14, 2002 at 12:20 pm #608416

      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.

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Swapping axes (1)

    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.