Results 1 to 6 of 6

Help!!! 3D scatter plot

This is a discussion on Help!!! 3D scatter plot within the Excel Questions forums, part of the Question Forums category; Hi, all, I am new to Excel 200 and need someone's help on 3-D scatter plot. I have a 3-dimensional ...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2

    Default

    Hi, all,

    I am new to Excel 200 and need someone's help on 3-D scatter plot.

    I have a 3-dimensional sample data, and I want to plot every sample as a point in x-y-z space. I just couldn't find any option in Chart. Any help/information is greatly appreciated.

    Sincerely,

    Lawrence

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040

    Default

    Hi,

    Cannot be done very well with Excel. No direct chart is available. I just read that SPSS has an add-in that you can purchase, but I've never seen it in action.

    Two workarounds...

    From Tushar Mehta:

    ...columns 1 and 2 contain x- and y-
    values, each of which is an independent variable. Column 3 contains the
    dependent z-values.

    Most 3-D plots I can think of require a surface (since both x and y are
    independent variables). Nonetheless, here is how to convert the data provided
    into a 3-D 'edge' plot.

    Leave the x-values in the column. Convert the y-values into a row (use Cut and
    Paste Special... Transpose). Take the z-values and put them in the diagonal of
    the table just created. Plot this table as a 3-D graph.

    ---- y values -----
    | z1
    | z2
    x z3
    values
    |
    | zlast


    From Bill Manville:

    If your X and Y values are on a regular grid you might get somewhere by making a pivot table from your data, with the first column as column field, the second as row field and the third as data field.

    Then you could make a 3-D surface graph from the resulting table

    Same idea.

    Both of these two are Excel MVPs, so you should be in fine shape, although you shouldn't expect a crystal clear graph as you hoped.

    HTH,
    Jay


  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2

    Default

    Hi, Jay,

    Thanks a lot.


    Lawrence

  4. #4
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Default Excel Add-in for 3D scatterplots

    If anyone is still looking for a way of producing 3D scatterplots in Excel, I have an add-in for free download at

    http://faculty.fuqua.duke.edu/~kamak...aDownloads.htm

    This simple add-in produces a xyz scatterplot and allows you to rotate it along any of the three dimensions.

  5. #5
    New Member
    Join Date
    Oct 2010
    Posts
    5

    Default Re: Excel Add-in for 3D scatterplots

    A quick update. The 3D scatterplot with labels (along with other free Excel add-ins for business analytics) are now available at http://wak2.web.rice.edu/

  6. #6
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Akron, Ohio USA
    Posts
    823

    Default Re: Excel Add-in for 3D scatterplots

    Another update: I ran across a company selling 5-D Scatterplots. In addition to the 3-D coordinates, you can control size of bubble and color of bubble:
    http://t.co/9qbzSHeC49
    View a collection of recent Excel articles in the Excel Daily News

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com