• Charts – X & Y Axis (Excel XP)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Charts – X & Y Axis (Excel XP)

    Author
    Topic
    WSmickeytor
    AskWoody Lounger
    October 1, 2003 at 7:11 pm #394437

    Is there a way to switch the X and Y axis around in an Excel chart? I tried rows to columns, but it only changes the X with the legend.

    Reply | Quote
    Viewing 3 reply threads
    Author
    Replies
    • WSchipshot
      AskWoody Lounger
      October 1, 2003 at 8:36 pm #722819

      In Excel 97, you can right click on the chart and select Source Data. Select the “Series” tab and you can respecify your X and Y values.

      Reply | Quote
    • WSchipshot
      AskWoody Lounger
      October 1, 2003 at 8:36 pm #722820

      In Excel 97, you can right click on the chart and select Source Data. Select the “Series” tab and you can respecify your X and Y values.

      Reply | Quote
    • WSsdckapr
      AskWoody Lounger
      October 1, 2003 at 8:58 pm #722831

      A simple way if the chart is on the same sheet as the data, is to select the range, which highlights (with colored boxes) around the legen, the x, and the y. with the mouse you can MOVE the boxes, reassigning the data ranges

      Steve

      Reply | Quote
    • WSsdckapr
      AskWoody Lounger
      October 1, 2003 at 8:58 pm #722832

      A simple way if the chart is on the same sheet as the data, is to select the range, which highlights (with colored boxes) around the legen, the x, and the y. with the mouse you can MOVE the boxes, reassigning the data ranges

      Steve

      Reply | Quote
    Viewing 3 reply threads
    Reply To: Charts – X & Y Axis (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.