XYZ coordinates in Excel graph 3D

[rejir007]

I have the following data:

X Axis - Years (2004, 2005 ,...)
Y Axis - Quantity (imported, exported, produaced)
Z- Axiz - Name of the products

I want to make a graph with teh X, y,z axis in excel. When i use the 3D graphs in excel, it is not taking the z vales connected to teh cell. Anybody can help me pllllllll

 

[Andrew Poulsom]

How is your data laid out. I had no problem creating a 3D Column Chart from this:

Book9
	A	B	C	D
1		Prod A	Prod B	Prod C
2	2004	54	27	51
3	2005	60	77	19
4	2006	80	16	16
Sheet1

 

[rejir007]

X,Y,Z coordinmates in Excel 3D Graph

Thanks for the Reply. But my data is given below:

Product A Product B Product C
2004 2005 2006
Import 55 800 5
Export 6 52 589
Production 89 759 700

X Axis - Years (2004, 2005 ,...)
Y Axis - Quantity (imported, exported, produced)
Z- Axiz - Name of the products

I want to make a graph with teh X, y,z axis in excel. When i use the 3D graphs in excel, it is not taking the z vales connected to the cell. Anybody can help me pllllllll

 

[Alto_HH]

Hello Reji,

try a bubble chart. The Z-Axis would be the bubble size.

Cheers

Alto

 

[Andrew Poulsom]

Sorry I don't understand that layout. You seem to have only 1 product each year.

 

[rejir007]

X,Y,Z coordinmates in Excel 3D Graph

Dear Andrew

Each year for each product there will be three figures, i.e import, export and production for Product A, Product, B, Product C, etc. So My visualization is that in X axis it si teh Years, In Y axis I can put the Data series, i'e, export, import production figures, and in Z axis teh Product names. so how it can be done

 

[Andrew Poulsom]

Like this?

Book1
	A	B	C	D	E
1			Prod A	Prod B	Prod C
2	Import	2004	44	96	5
3	Export		54	53	95
4	Production		22	2	90
5	Import	2005	27	24	66
6	Export		24	63	73
7	Production		59	80	7
8	Import	2006	29	58	52
9	Export		82	96	57
10	Production		48	54	63
Sheet1

 

[rejir007]

X,Y,Z coordinmates in Excel 3D Graph

Yes Mr. Andrews the data can be like this also plesae davise me

 

[Andrew Poulsom]

Did you try plotting that data as a 3_D Column Chart?

 

[rejir007]

X,Y,Z coordinmates in Excel 3D Graph

Yes i tried. But it si not taking the value of Z axis. i.e the name of the products