+ Reply to Thread
Results 1 to 19 of 19

xy charts??

Hybrid View

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

    Re: xy charts??

    I can visualize a simple surface (= 2 dimensional?) chart with independent variables on the x and y axes respectively and the dependent values graphed against each. As I said I've a feeling that x y charts do this, with or without dual axes, but I can't quite figure out how to do it. Trial and error?
    Last edited by teylyn; 04-02-2010 at 09:37 PM. Reason: removed spurious quote

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: xy charts??

    I have a feeling that no x-y charts do this. You need need three independent axes.
    Entia non sunt multiplicanda sine necessitate

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

    Re: xy charts??

    If you wanted to chart (for example) the second hand values of a model of a car against the age and the mileage as displayed in various used car adverts, I can't see why Excel cannot do this (without resorting to 3 axes - I can't think in 3 dimensions!). There are only two independent variables to go on 2 independent axes. I thought this was what x y charts were designed to do.
    Last edited by teylyn; 04-02-2010 at 09:37 PM. Reason: removed spurious quote

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: xy charts??

    Maybe. Draw one by hand, scan it and post it.

  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??

    for xyz points you can try this
    http://www.andypope.info/charts/3drotate.htm
    Cheers
    Andy
    www.andypope.info

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

    Re: xy charts??

    Tks - the contents look really interesting even if I don't believe that for my simple purposes it's necessary to go to 3 dimensions let alone rotate them! I just need to get the hang of using standard xy charts properly and I suspect that somewhere within what you've sent will be the answer. Weekend's work ahead ..
    Last edited by teylyn; 04-02-2010 at 09:37 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??

    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

+ 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