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:

	0,0</SPAN>	13,5</SPAN>	26,6</SPAN>	39,4</SPAN>	51,9</SPAN>
0,0</SPAN>	108,7	90,5	90,5	90,5	93,1
1,0</SPAN>	108,3	90,5	90,5	90,5	90,6
2,0</SPAN>	108,3	90,5	90,5	90,5	90,5
3,0</SPAN>	108,3	90,5	90,5	90,5	90,5
4,0</SPAN>	108,3	90,5	90,5	90,5	90,5
5,0</SPAN>	108,3	90,5	90,5	90,5	90,5

<TBODY>
</TBODY><COLGROUP><COL span=6></COLGROUP>

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!