MS Excel has standard chart types for this:
...or this:
...or this:
...but not this:
(larger view, 176 kB JPEG)
The macro in the workbook below gives MS Excel the ability to create a proper 3D scatterplot
from a range of selected cells. The chart has these properties:
- Display points with arbitrary X/Y/Z values
- Rotate the plot freely in all three dimensions
- Option to color points according to Z value
- Option to create dynamic labels for each point
Inspired by Andy Pope's "Simulated 3d XY scatter"
http://www.andypope.info/charts.htm
This ZIP archive contains an Excel woorkbook with the necessary VBA macros and a PDF manual. The VBA code is free software. See GNU General Public License for
details.
Download Excel3Dscatterplotv1_02.zip (397 kB ZIP).
You are encouraged to send me nice samples of plots you have created with the help of this macro:
Gabor Doka: scaplo {at} doka {dot} ch
If you encounter problems, please contact me:
Gabor Doka: scaplo {at} doka {dot} ch
The worksheet above was created with Excel 11.0 (2004), but should be running on other versions too
(However Excel 2008 for Mac does not have any VBA macro capability, but v2011 does again).
Copyleft © 2006-2010 Gabor Doka (scaplo {at} doka {dot} ch)
The 'Excel 3D Scatter Plot' macros are provided free of charge. They may be distributed freely provided
that all the macros and documentation are always distributed together, in whole and unchanged.
The 'Excel 3D Scatter Plot' macros may not be sold or offered for sale, or included with another
software product offered for sale. Companies that distribute public domain/freeware/shareware
software for profit are expressly prohibited from distributing the 'Excel 3D Scatter Plot' macros.
Programs in the distributed Excel document come with absolutely no warranty. These are free softwares, and you
are welcome to redistribute them under certain conditions. See GNU General Public License for
details.
(larger view, 176 kB JPEG)
Doka Life Cycle Assessments