# 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. 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. 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. Hi, Jay,

Thanks a lot.

Lawrence

4. ## Excel Add-in for 3D scatterplots

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

5. ## 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. ## 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

#### Posting Permissions

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