If column 2 (number of proteins) is such that all the values are
equidistant (the values are 1,2,3,4, etc., or 8,16,24,32, etc.) then
category or numerical will yield similar looking results.

If not, you cannot do a 3D graph a la XL. Andy Pope shows how to
simulate one at http://www.andypope.info/charts/3drotate.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <alex_marshall.1trc6i_1124028330.0148@excelforum-
nospam.com,
says...

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


--
alex_marshall
------------------------------------------------------------------------
alex_marshall's Profile: http://www.excelforum.com/member.php...o&userid=26274
View this thread: http://www.excelforum.com/showthread...hreadid=395659