+ Reply to Thread
Results 1 to 4 of 4

set values as x axis and y axis in excel chart and name points

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    set values as x axis and y axis in excel chart and name points

    Copy of Book1 (5).xlsx

    Attached the file and how far I've gotten!

    Hiho,

    I have this data.
    Please Login or Register  to view this content.
    I want to set EE as the X asis and PE as the Y axis, and then just mark where they cross eachother.

    I can't figuere out how to set this up in excel-scatter charts.

    Anyone know how?

    Regards,
    Christopher


    EDIT:

    Okay, I've managed to get the scatter and axis right, but now I want to name the scatter points and axis, can't figuere that out :p
    Last edited by christopherL; 08-27-2014 at 10:02 AM. Reason: half solved

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: set values as x axis and y axis in excel chart and name points

    Sounds more like a Line graph than a scatter...?
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Registered User
    Join Date
    10-11-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2002
    Posts
    71

    Re: set values as x axis and y axis in excel chart and name points

    Quote Originally Posted by Speshul View Post
    Sounds more like a Line graph than a scatter...?
    Heey,
    I attached my file if you maybe could look and see what I am trying to accomplish?

    Right now I mostly want to name the axis and name the scattered points :/

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: set values as x axis and y axis in excel chart and name points

    It is not clear to me what you are trying to do.

    To add titles to a chart axis, follow these instructions: http://office.microsoft.com/en-us/ex...CTT=1#BMtitles

    To label the individual data points with the different "markets" text, use the free "XY chart labeler" add-in from appspro.com
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. 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
  2. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  3. Replies: 2
    Last Post: 02-07-2014, 12:18 PM
  4. Replies: 2
    Last Post: 01-27-2014, 06:52 PM
  5. [SOLVED] Chart when x-axis contains only points for which y-values exist??
    By Alexander_Golinsky in forum Excel General
    Replies: 2
    Last Post: 05-05-2012, 11:00 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