Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts - X & Y Axis (Excel XP)

    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.

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts - X & Y Axis (Excel XP)

    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.

  3. #3
    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: Charts - X & Y Axis (Excel XP)

    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

Posting Permissions

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