+ Reply to Thread
Results 1 to 3 of 3

Numerical x and y axis on chart

  1. #1
    Registered User
    Join Date
    12-08-2015
    Location
    Birmingham, England
    MS-Off Ver
    2007
    Posts
    44

    Numerical x and y axis on chart

    Hi,

    I am trying to create a line graph using the following sample of data:

    A B
    0.904 1.967
    1.179 1.944
    1.435 2.017
    1.469 1.964
    0.933 1.871
    1.187 2.049
    1.144 2.029
    1.136 1.997
    1.383 2.09
    1.315 2.091
    1.326 2.113
    1.253 1.976
    1.236 1.928

    So I need A on the vertical axis and B on the horizontal axis with one line on the chart. Is that even possible?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Numerical x and y axis on chart

    Use an XY scatter chart
    Ben Van Johnson

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Numerical x and y axis on chart

    Note excel expects x values in the first column, so in order to have those values treated as the vertical points you will need to change the data layout or use the select data dialog to change which columns are used for x and y data.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  2. Replies: 5
    Last Post: 03-28-2015, 03:48 PM
  3. Bubbel Chart with non-numerical values for both X axis and Y axis
    By air15567 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-29-2014, 11:25 AM
  4. Stacked columns chart - use non-numerical data in the vertical axis
    By guillermo_A in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-01-2014, 09:35 AM
  5. [SOLVED] How Do I Hide Zero Value Axis Titles where the axis is a text value and not numerical
    By krish2503 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2014, 04:01 PM
  6. Changing Y Axis to Non-numerical value for Stacked Column Chart
    By Sweetsting in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-05-2013, 02:44 AM
  7. [SOLVED] Changing Y-Axis Labels from Numerical to Textual
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-12-2005, 06:45 AM

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