+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Graphing, Switching X and Y axis

  1. #1
    Registered User
    Join Date
    01-04-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Graphing, Switching X and Y axis

    Please help me out with this.

    All I'm tring to do is switch my graph so that Weight is running upwards , and Electric Field strenth is running Horizontally. See Attachment

    I've been searching on how to do this for probably about 4 hours . Please someone tell me , detailed on how to solve what seems like it should be SIMPLE
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    12-21-2009
    Location
    Lincoln, NE
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Graphing, Switching X and Y axis

    The simplest solution is to go to the excel chart in question, right click and click on 'select data'. Go to 'Edit' and select the correct x and y axis for your data.

  3. #3
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Graphing, Switching X and Y axis

    The can be done as in the attached. I've taken a list of values and used lookup functions.
    Attached Files Attached Files
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1