how do i create an XYZ chart?

J

Jeromy

i want to make a 3D chart from my series of 3 dimensional points (3 columns)
but it appears excel cant do it.
 
J

Jon Peltier

Excel has only the most rudimentary 3D charting capabilities, mostly
along the lines of adding 3D effects to a perfectly good 2D chart.

Andy Pope has a working example showing how to use formulas and a 2D XY
chart to fake a 3D XYZ chart:

http://andypope.info

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Ways to create a budget chart for money managment 1
How to create a bubble chart with more than 2 variables. 0
Move Chart with Text 0
washed out charts 3
Dynamic Chart Title With 3D Stacked Column Chart 2
Creating a Chart on form from selected data in query. 0
Possible to Combine reports to's to a single box? 0

Top