Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Help!!! 3D scatter plot

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, Jay,

    Thanks a lot.


    Lawrence

  4. #4
    New Member
    Join Date
    Oct 2010
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Merritt Island Florida
    Posts
    861
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    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

Some videos you may like

User Tag List

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
  •