Using 3D Scatter Plot in Microsoft Excel
The 'Excel 3D Scatter Plot' macro – The Manual
Copyleft by Gabor Doka, Switzerland, © 2006 – 2012 reach the author under: scaplo {at} doka {dot} ch
A very quick introduction:
A first chart
1. Open the workbook "3Dscatterplot.xls" that contains the necessary macros. 2. In a trial workbook enter some data you want to display in three columns (x,y,z). 3. Optionally you can enter a header column containing text labels for each point. 4. Leave 10 empty rows above the data range and one empty column to the left. 5. Select the data (3 columns) or the data + label text (4 columns). Don't select the top row containing labels for the three axes. 6. Run the macro "Make3DscatterplotFromDataRange" and wait a moment (5 – 10 seconds, longer, if data labels are involved)
4 columns selected (step 5) looks like this:
(label text, X, Y, Z)
With the created scroll bars i.e you can rotate the viewpoint and move 3 orthogonal projection planes (= cut planes). Coloring the chart points according to z value: (What follows will change the color palette of your whole workbook and all its contained sheets. If color-coded info is important in your workbook, please try this on a trial workbook only). 7. Run the macro "MakeNiceGradientColorPalette" 8. Select a chart series in the plot 9. Run the macro "ColorSeriesPoints" and choose 3 in the dialog The basic workings of these macros are explained in the steps above. If you want to be better informed, read on. page 1 of 9
3D scatter plot in Excel – the Manual
The Extended Manual
A very quick introduction: .................................................................................................... 1 A first chart ...........................................................................................................................1 The Extended Manual ........................................................................................................... 2 3D scatter plot
Copyleft by Gabor Doka, Switzerland, © 2006 – 2012 reach the author under: scaplo {at} doka {dot} ch
A very quick introduction:
A first chart
1. Open the workbook "3Dscatterplot.xls" that contains the necessary macros. 2. In a trial workbook enter some data you want to display in three columns (x,y,z). 3. Optionally you can enter a header column containing text labels for each point. 4. Leave 10 empty rows above the data range and one empty column to the left. 5. Select the data (3 columns) or the data + label text (4 columns). Don't select the top row containing labels for the three axes. 6. Run the macro "Make3DscatterplotFromDataRange" and wait a moment (5 – 10 seconds, longer, if data labels are involved)
4 columns selected (step 5) looks like this:
(label text, X, Y, Z)
With the created scroll bars i.e you can rotate the viewpoint and move 3 orthogonal projection planes (= cut planes). Coloring the chart points according to z value: (What follows will change the color palette of your whole workbook and all its contained sheets. If color-coded info is important in your workbook, please try this on a trial workbook only). 7. Run the macro "MakeNiceGradientColorPalette" 8. Select a chart series in the plot 9. Run the macro "ColorSeriesPoints" and choose 3 in the dialog The basic workings of these macros are explained in the steps above. If you want to be better informed, read on. page 1 of 9
3D scatter plot in Excel – the Manual
The Extended Manual
A very quick introduction: .................................................................................................... 1 A first chart ...........................................................................................................................1 The Extended Manual ........................................................................................................... 2 3D scatter plot