ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do i create an XYZ chart? (https://www.excelbanter.com/charts-charting-excel/39378-how-do-i-create-xyz-chart.html)

Jeromy

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

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/
_______


Jeromy wrote:

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



All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com