Using 3D Scatter Plot in Microsoft Excel

Topics: Color, Scatter plot, RGB color model Pages: 12 (4152 words) Published: March 17, 2013
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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • penn foster microsoft excel Essay
  • Using Microsoft Excel Essay
  • Microsoft Excel Essay
  • How to Make Graphs Using Microsoft Excel 2011 Essay
  • Microsoft Excel Essay
  • Microsoft Access and Excel: Essay
  • Using Excel Spreadsheet Essay
  • Statistics Using Excel Essay

Become a StudyMode Member

Sign Up - It's Free