# XYZ coordinates in Excel graph 3D

#### rejir007

##### New Member
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

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### Andrew Poulsom

##### MrExcel MVP
How is your data laid out. I had no problem creating a 3D Column Chart from this:
Book9
ABCD
1Prod AProd BProd C
22004542751
32005607719
42006801616
Sheet1

#### rejir007

##### New Member
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

##### New Member
Hello Reji,

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

Cheers

Alto

#### Andrew Poulsom

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

#### rejir007

##### New Member
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

##### MrExcel MVP
Like this?
Book1
ABCDE
1Prod AProd BProd C
2Import200444965
3Export545395
4Production22290
5Import2005272466
6Export246373
7Production59807
8Import2006295852
9Export829657
10Production485463
Sheet1

#### rejir007

##### New Member
X,Y,Z coordinmates in Excel 3D Graph

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

#### Andrew Poulsom

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

#### rejir007

##### New Member
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

Replies
0
Views
327
Replies
1
Views
549
Replies
3
Views
454
Replies
2
Views
346
Replies
2
Views
392

1,191,690
Messages
5,988,104
Members
440,126
Latest member
duque00

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back