Can you plot a graph with 3 axes e.g. xyz values on Excel?
 

Can you plot a graph with 3 axes e.g. xyz values?

Answer: Can you plot a graph with 3 axes e.g. xyz values on Excel?
 

Yes, you can plot a graph with 3 axes (x, y, and z) in Excel. Here's how you can do it:

1. Enter your data in three columns, with the x-values in the first column, the y-values in the second column, and the z-values in the third column.
2. Select the data range and click on the "Insert" tab in the ribbon.
3. Click on the "Insert Scatter (X, Y) or Bubble Chart" button and select the "3-D Scatter" option.
4. Excel will create a 3-D scatter plot with the x-axis, y-axis, and z-axis.
5. You can customize the chart by adding a chart title, axis titles, and adjusting the axis scales.
6. To rotate the chart, click on the chart and use the rotation handles to adjust the view.
7. You can also add data labels to the chart by right-clicking on a data point and selecting "Add Data Labels".

That's it! You now have a 3-D scatter plot with x, y, and z axes in Excel.

Excel doesn't have a native 3D XYZ chart format, but Andy Pope shows how
to fake it on his web site

http://andypope.info

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


Khan wrote:
Can you plot a graph with 3 axes e.g. xyz values?

In article ,
says...
Can you plot a graph with 3 axes e.g. xyz values?

For an understanding of what you can do with XL (it's quite limited)
see
3D Surface
http://www.tushar-mehta.com/excel/ch...ace/index.html

--
Regards,

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

For 3D XYZ chart you can use projection:

http://www.maclab.sk/clanky/en-3d-graph-excel.php