Think of the series axis as another category axis.

You have to turn the data from a list to a grid. A pivot table will
probably do the trick. It must look like this:

Y1 Y2 Y3 Y4
X1 Z11 Z12 Z13 Z14
X1 Z21 Z22 Z23 Z24
X3 Z31 Z32 Z33 Z34
X4 Z41 Z42 Z43 Z44

This produces a surface or contour chart.

If this is the approach you need, you might want to look at an article I
wrote on contour and surface charts in Excel:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

If not, follow up Tushar's suggestion of Andy Pope's simulated 3D XYZ chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


alex_marshall wrote:

Dear All :)

I understand in an excel 3d graph the x axis is a category axis, the y
axis
is a series axis and the z axis is a numerical axis.

I need to create a 3D graph with a category x axis, a numerical y and z

axis.

I have 3 columns in my spreadsheet: -

column 1 - database names
column 2 - number of proteins
column 3 - number of genes

So far, the 3D graphs I am creating a- column 1 as the x axis, the y
axis
is the series - so contains 2 series (proteins and genes) and the z
axis is
numerical (so proteins and genes are read off this). This wrong... :(


So, how do I get column 1 as the x axis, column 2 as the y axis
(numerical
values - proteins) and column 3 as the z axis (numerical values -
genes)?

Thanks