3d graph with two real variables and one name string

[Murcielago]

Dear fellow excellers,

I've been working on representing some data with a three-dimensional graph, but can't seem to get the results that I'm looking for. The problem is having two real variables and one set of labels (1,2,3...). I tried putting the data in a "3d area" graph, but it only uses 1 true variable and two sets of labels, or variables with constant intervals. The graph itself would otherwise be a perfect representation of the data.

An example of my data can be found below:

[TABLE="width: 424"]
<TBODY>[TR]
[TD] [/TD]
[TD]0,0</SPAN>[/TD]
[TD]13,5</SPAN>[/TD]
[TD]26,6</SPAN>[/TD]
[TD]39,4</SPAN>[/TD]
[TD]51,9</SPAN>[/TD]
[/TR]
[TR]
[TD]0,0</SPAN>[/TD]
[TD]108,7[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]93,1[/TD]
[/TR]
[TR]
[TD]1,0</SPAN>[/TD]
[TD]108,3[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,6[/TD]
[/TR]
[TR]
[TD]2,0</SPAN>[/TD]
[TD]108,3[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[/TR]
[TR]
[TD]3,0</SPAN>[/TD]
[TD]108,3[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[/TR]
[TR]
[TD]4,0</SPAN>[/TD]
[TD]108,3[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[/TR]
[TR]
[TD]5,0</SPAN>[/TD]
[TD]108,3[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[TD]90,5[/TD]
[/TR]
</TBODY><COLGROUP><COL span=6></COLGROUP>[/TABLE]


I would like to plot the column in bold values as the x-axis, row in bold as z-axis and the rest as y-axis. The problem is having constant intervals between 0,0...51,9 , instead of variable intervals. Any idea on how to plot this?

I have ~130 000 cells of data, so I can't really do any manual work.

I would appreciate any help in this!

 

[sijpie]

The native chart formats in Excel are not sufficient for this, but these links have some usefl resources. With the first link you can download a spreadsheet with macros to produce beautiful graphs, (see the examples in the website), with the most flexibility. The others also have worksheets or add-ins.

3d scatter plot for MS Excel Recommended!

http://faculty.fuqua.duke.edu/~kamak...aDownloads.htm
AJP Excel Information - XYZ plot

 

[Murcielago]

Thank you so much sijpie - this looks just like what I needed!

I'll let you know how this works out

 

[Murcielago]

Hello,

I wanted to update this. Eventually I found out that this kind of 3d scatter plot is pretty difficult to use for this amount of data, especially when I don't have my data neatly organized in individual points of X, Y, Z.

I was able to resolve my problems and use the native 3d plot for excel, however. I was able to do this by performing some extra computing for my values - now they follow a certain logic. After that I replaced my z-axis with values that have constant intervals, so now the native graph works just fine.

Anyway, thanks for the help!