How to plot x,y,z graphs? 
Author Message
 How to plot x,y,z graphs?

Does anybody know of an addin or method of plotting 3D graphs in XL?

thanks, Jo



Wed, 18 Jun 1902 08:00:00 GMT  
 How to plot x,y,z graphs?
Joss Stick  -

Quote:
> Does anybody know of an addin or method of plotting 3D graphs in XL?

Blank cell in top left corner, equally-spaced X values to the right in a
row, equally-spaced Y values below in a column, Z = F(X,Y) values in cells
at intersection of X and Y. Select entire array. Use the Chart Wizard
(Surface or Column 3D).

-  Mike Middleton



Wed, 18 Jun 1902 08:00:00 GMT  
 How to plot x,y,z graphs?
Thanks, Mike. Thing is, I have three columns (x,y,z). Do you know how I can
(easily) arrange the z column to run diagonally from the top left to bottom
right? I have about 100 sets of co-ordinates.

cheers, Jo


Quote:
> Joss Stick  -

> > Does anybody know of an addin or method of plotting 3D graphs in XL?

> Blank cell in top left corner, equally-spaced X values to the right in a
> row, equally-spaced Y values below in a column, Z = F(X,Y) values in cells
> at intersection of X and Y. Select entire array. Use the Chart Wizard
> (Surface or Column 3D).

> -  Mike Middleton



Wed, 18 Jun 1902 08:00:00 GMT  
 How to plot x,y,z graphs?
Jo  -

Quote:
> Thanks, Mike. Thing is, I have three columns (x,y,z). Do you know how I
can
> (easily) arrange the z column to run diagonally from the top left to
bottom
> right? I have about 100 sets of co-ordinates.

Use a pivot table. Then copy, paste special values, and clear contents in
top left corner.

Since X and Y axes are category labels, irrespective of numerical values,
the 3D chart will be distorted unless the X and Y values are numerically
equally spaced.

Quote:
> > Blank cell in top left corner, equally-spaced X values to the right in a
> > row, equally-spaced Y values below in a column, Z = F(X,Y) values in
cells
> > at intersection of X and Y. Select entire array. Use the Chart Wizard
> > (Surface or Column 3D).

-  Mike Middleton


Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Excel 97 Graph Problem: Plot Empty Cells as Not Plotted

2. Vba to plot points and create graph

3. Charts ----- line graph, when I hide data in a worksheet the plot also is hidden

4. Overlaying discrete variable plot on graph

5. Graph Data Labels in Scatter Plot

6. Trouble plotting data in a graph

7. Plotting/Graphing a normal distribution of numbers

8. Problem resizing the Plot Area of a graph

9. Graph Plotting

10. Help plotting scatter graphs


 
Powered by phpBB® Forum Software © phpBB Group