3d scatterplot - rotate.xls

Entering DataEnter your(x,y,z)data into columns A,B,and C,one data point per row.Formulasin the worksheet transform the data,and the chart is actually displaying the data incolumns P and Q(Chart Data).You can use any number of data points,but you may need to adjust the entries incolumns M:Q(Transformed Data and Chart Data)to accommodate the data.Also,youll need to adjust the range used by the chart series.Rotating the ChartUse the three scrollers to rotate the chart manually.Or,click the buttons to get ananimated rotation.Show AxisThis checkbox executes a macro to control the visibility of the three(x,y,and z)axes.Note that each of these axes is actually a separate data series in the chart,stored in columns V and W.Show CubeThis checkbox executes a macro to control the visibility of the cube that enclosesthe plotted data.The cube(and the axes)can often make it easier to visualize thedata as it is rotated.Note that this cube actually consists of six additional dataseries,stored in columns V and W.Show DataThis checkbox executes a macro to control the visibility of the data seriesData ScalingThese option buttons determine the type of scaling used in the chart,and is linked tocell C2(Scaling).The original data is transformed such that it has a minimum of-3and a maximum of+3.If you select the Single scale for all data option,all of the data uses the samescaling.This option will show the data most accurately,but one or more dimensionsof the chart may not be filled completely.This option is suitable for data that has asimilar scale for all three dimensions.If you select the Separate x,y,and z scalingoption,each dimension is scaled separately.This option may distort thecross-dimensional differences in the data,but it will produce an acceptable chartfor all data.Performance IssuesRotating the chart involves many recalculations.For best results,dont have anyother workbooks open-especially those that are calculation-intensive.To fine-tine the rotation speed,access the VB Editor and change the Incrementvalues in Module1.AcknowledgementThis workbook is based on a file originally created by Andy Pope.I added themacros and scaling options.John WalkenbachJWalk&Associateshttp:/j- AnglesXYYXYZXYZMin8.000-0.182-0.2128.000.25-0.04000Max43.4000.2470.1538.600.17-0.16Slope0.16913.98116.4399.200.05-0.21Y-int-4.356-0.4580.4849.80-0.07-0.1910.40-0.16-0.11Transformed Data11.00-0.180.00XYZ11.60-0.140.10-3.003.00-0.1112.20-0.060.15-2.901.93-2.1112.800.040.15-2.800.22-3.0013.400.110.10-2.69-1.50-2.6414.000.140.02-2.59-2.68-1.2914.600.12-0.06-2.49-3.000.5015.200.06-0.11-2.39-2.442.0915.80-0.01-0.13-2.29-1.283.0016.40-0.08-0.09-2.190.052.9817.00-0.11-0.03-2.081.092.1317.60-0.110.04-1.981.520.8118.20-0.070.09-1.881.26-0.5218.80-0.010.11-1.780.44-1.4119.400.050.09-1.68-0.62-1.5920.000.090.04-1.58-1.55-1.0620.600.10-0.02-1.47-2.04-0.0521.200.07-0.07-1.37-1.971.0721.800.02-0.09-1.27-1.391.9222.40-0.04-0.08-1.17-0.532.2323.00-0.07-0.05-1.070.301.9323.60-0.080.00-0.970.821.1524.20-0070.05-0.860.880.2024.80-0.030.08-0.760.48-0.6125.400.020.08-0.66-0.21-1.0026.000.060.050-0.56-0.95-0.8626.600.070.01-0.46-1.49-0.2827.200.06-0.04-0.36-1.640.5427.800.03-0.06-0.25-1.391.29Show AxesShow CubeShow DataData scalingSingle scale for all dataSeparate x,y,z scaling28.40-0.01-0.07-0.15-0.831.7429.00-0.05-0.05-0.05-0.171.7329.60-0.07-0.020.050.361.3030.20-0.060.020.150.590.6130.80-0.040.050.250.45-0.0931.400.000.060.360.00-0.5732.000.030.050.46-0.58-0.6632.600.060.020.56-1.10-0.3633.200.06-0.010.66-1.370.2133.800.04-0.040.76-1.330.8634.400.01-0.060.86-0.981.3635.00-0.02-0.050.97-0.471.5335.60-0.05-0.031.070.021.3436.20-0.060.001.170.340.8636.80-0.040.031.270.370.2737.40-0.020.051.370.11-0.2238.000.020.051.47-0.33-0.4638.600.040.031.58-0.80-0.3739.200.050.001.68-1.140.0239.800.04-0.031.78-1.230.5540.400.02-0.041.88-1.051.0441.00-0.01-0.051.98-0.681.3241.60-0.03-0.032.08-0.241.314220-0.05-0.012.190.111.0142.80-0.040.022.290.250.5443.40-0.030.042.390.150.072.49-0.16-0.252.59-0.57-0.312.69-0.92-0.092.80-1.110.322.90-1.060.773.00-0.811.12AllScaling:Calculated Angles-0.2122XYZ43.400Radians0.0000.0000.0000.138SIN0.0000.0000.000-2.971COS1.0001.0001.000RotationMatrixChart Data1.0000.0000.000XY0.0001.0000.000-3.0003.000-2.8981.930X AxisXY-2.7970.219-300-3.0000.000-2.695-1.5043003.0000.000-2.593-2.684Y AxisXY-2.492-3.0000-300.000-3.000-2.390-2.4410300.0003.000-2.288-1.279Z AxisXY-2.1860.04800-30.0000.000-2.0851.0870030.0000.000-1.9831.520Cube FrontXY-1.8811.2563-333.000-3.000-17800.4373333.0003.000-1.678-0.621-333-3.0003.000-1.576-1.546-3-33-3.000-3.000-1.475-2.0393-333.000-3.000-1.373-1.966Cube BackXY-1.271-1.387-3-3-3-3.000-3.000-1.169-0.5323-3-33.000-3.000-1.0680.29633-33.0003.000-0.9660.818-33-3-3.0003.000-0.8640.877-3-3-3-3.000-3.000-0.7630.480Cube Upper Edge LeftXY0.661-0.214-33-3-3.0003.000-0.559-0.954-333-3.0003.000-0.458-1.487Cube Upper Edge RightXY-0.356-1.64233-33.0003.000-0.254-1.3863333.0003.000-0.153-0.826Cube Lower Edge RightXY-0.051-0.1673-3-33.000-3.0000.0510.3623-333.000-3.0000.1530.588Cube Lower Edge LeftXY0.2540.446-3-3-3-3.000-3.0000.3560.001-3-33-3.000-3.0000.458-0.5810.559-1.0980.661-1.3740.763-1.3260.864-0.9830.966-0.4721.0680.0241.1690.3361.2710.3651.3730.1101.475-0.3311.576-0.8001.678-1.1361.780-1.2281.881-1.0531.983-0.6782.085-0.2402.1860.1102.2880.2542.3900.1482.492-0.1632.593-0.5662.695-0.9212.797-1.1062.898-1.0633.000-0.812