Help!!! 3D scatter plot

LawrenceYSun

New Member
Joined
Apr 7, 2002
Messages
2
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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top