Using 3D Scatter Plot in Microsoft Excel

Only available on StudyMode
  • Topic: Color, Scatter plot, RGB color model
  • Pages : 12 (4152 words )
  • Download(s) : 51
  • Published : March 17, 2013
Open Document
Text Preview
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 ......................................................................................................................2 Interactive Display..........................................................................................................................................2 Remove projection planes ................................................................................................................................2 Adding more data points ..................................................................................................................................2 Removing data points......................................................................................................................................3 Bounding box ................................................................................................................................................3 3D Realism....................................................................................................................................................3 Data labels ....................................................................................................................................................3 Re-doing a plot ..............................................................................................................................................4

Changing the Color Palette .....................................................................................................4 Color coding ..........................................................................................................................5 Behaviour of color information to changing data ...................................................................................................5 Coloring the projection planes...........................................................................................................................5 Marker formatting...
tracking img