+ Reply to Thread
Results 1 to 19 of 19

xy charts??

Hybrid View

Telegraph Sam xy charts?? 04-01-2010, 03:45 PM
shg Re: xy charts?? 04-01-2010, 04:05 PM
Telegraph Sam Re: xy charts?? 04-01-2010, 04:18 PM
shg Re: xy charts?? 04-01-2010, 04:45 PM
Telegraph Sam Re: xy charts?? 04-01-2010, 05:10 PM
shg Re: xy charts?? 04-01-2010, 07:01 PM
Andy Pope Re: xy charts?? 04-02-2010, 04:35 AM
Telegraph Sam Re: xy charts?? 04-02-2010, 07:25 AM
Andy Pope Re: xy charts?? 04-02-2010, 07:29 AM
Telegraph Sam Re: xy charts?? 04-02-2010, 07:48 AM
Andy Pope Re: xy charts?? 04-02-2010, 07:52 AM
Telegraph Sam Re: xy charts?? 04-02-2010, 08:07 AM
Andy Pope Re: xy charts?? 04-02-2010, 08:13 AM
Telegraph Sam Re: xy charts?? 04-02-2010, 09:18 AM
teylyn Re: xy charts?? 04-02-2010, 09:36 PM
Andy Pope Re: xy charts?? 04-03-2010, 05:57 AM
Telegraph Sam Re: xy charts?? 04-03-2010, 05:16 PM
  1. #1
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: xy charts??

    Probably for you example of the car you need

    X axis milage
    Y axis age
    Data label text is the car and cost

    Use this free addin to link data labels to cells.
    http://www.appspro.com/Utilities/ChartLabeler.htm
    Cheers
    Andy
    www.andypope.info

  2. #2
    Registered User
    Join Date
    04-01-2010
    Location
    Chester-le-Street, England
    MS-Off Ver
    Excel 2016
    Posts
    91

    Re: xy charts??

    Great minds think alike. This is what I had in mind to progress to if and when I succeed in getting the 2-dimensional basics to work using what you sent previously (incl. how to lay out the raw data so that the chart picks it up properly)
    Last edited by teylyn; 04-02-2010 at 09:38 PM. Reason: removed spurious quote

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

    Re: xy charts??

    for 5 pairs of value I would layout like this.

    A2:A6 contains X values
    B2:B6 contains Y values
    B1 contains text to label series

    Select A1:B6 and create a single series XY scatter.

  4. #4
    Registered User
    Join Date
    04-01-2010
    Location
    Chester-le-Street, England
    MS-Off Ver
    Excel 2016
    Posts
    91

    Re: xy charts??

    Tks for realtime response! I'll have to experiment with this because in my case there is no direct correlation between the values in A2:A6 and B2:B6 as would be implied (both are "independent"). May be the xy graph function can accomodate this somehow. I have got my raw data set out in 2-D matrix form but haven't yet tried to "scatter" graph it.
    Last edited by teylyn; 04-02-2010 at 09:38 PM. Reason: removed spurious quote

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

    Re: xy charts??

    You will need to alter the layout of your data.
    Creating a 2 column list where each Row value is repeated for the unique Col value.

  6. #6
    Registered User
    Join Date
    04-01-2010
    Location
    Chester-le-Street, England
    MS-Off Ver
    Excel 2016
    Posts
    91

    Re: xy charts??

    Sorry you've lost me there. I have attached an imaginary simple example of what I am trying to chart. May be you could show me what you mean using this.
    Attached Files Attached Files
    Last edited by teylyn; 04-02-2010 at 09:38 PM. Reason: removed spurious quote

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

    Re: xy charts??

    This uses the index formula with a few IF tests to suppress empty matrix cells for outputting point or label.
    Attached Files Attached Files

+ 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