Excel3D图.xls

Entering Data Enter your x y z data into columns A B and C one data point per row Formulas in the worksheet transform the data and the chart is actually displaying the data in columns P and Q Chart Data You can use any number of data points but you may need to adjust the entries in columns M Q Transformed Data and Chart Data to accommodate the data Also you ll need to adjust the range used by the chart series Rotating the Chart Use the three scrollers to rotate the chart manually Or click the buttons to get an animated rotation Show Axis This 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 Cube This checkbox executes a macro to control the visibility of the cube that encloses the plotted data The cube and the axes can often make it easier to visualize the data as it is rotated Note that this cube actually consists of six additional data series stored in columns V and W Show Data This checkbox executes a macro to control the visibility of the data series Data Scaling These option buttons determine the type of scaling used in the chart and is linked to cell C2 Scaling The original data is transformed such that it has a minimum of 3 and a maximum of 3 If you select the Single scale for all data option all of the data uses the same scaling This option will show the data most accurately but one or more dimensions of the chart may not be filled completely This option is suitable for data that has a similar scale for all three dimensions If you select the Separate x y and z scaling option each dimension is scaled separately This option may distort the cross dimensional differences in the data but it will produce an acceptable chart for all data Performance Issues Rotating the chart involves many recalculations For best results don t have any other workbooks open especially those that are calculation intensive To fine tine the rotation speed access the VB Editor and change the Increment values in Module1 Acknowledgement This workbook is based on a file originally created by Andy Pope I added the macros and scaling options John Walkenbach JWalk Associates http j DataAxes AnglesXYY XYZXYZMin8 000 0 182 0 212 8 000 25 0 0411228Max43 4000 2470 153 8 600 17 0 16Slope0 16913 98116 439 9 200 05 0 21Y int 4 356 0 4580 484 9 80 0 07 0 19 10 40 0 16 0 11Transformed Data 11 00 0 180 00XYZ 11 60 0 140 10 3 003 00 0 11 12 20 0 060 15 2 901 93 2 11 12 800 040 15 2 800 22 3 00 13 400 110 10 2 69 1 50 2 64 14 000 140 02 2 59 2 68 1 29 14 600 12 0 06 2 49 3 000 50 15 200 06 0 11 2 39 2 442 09 15 80 0 01 0 13 2 29 1 283 00 16 40 0 08 0 09 2 190 052 98 17 00 0 11 0 03 2 081 092 13 17 60 0 110 04 1 981 520 81 18 20 0 070 09 1 881 26 0 52 18 80 0 010 11 1 780 44 1 41 19 400 050 09 1 68 0 62 1 59 20 000 090 04 1 58 1 55 1 06 20 600 10 0 02 1 47 2 04 0 05 21 200 07 0 07 1 37 1 971 07 21 800 02 0 09 1 27 1 391 92 22 40 0 04 0 08 1 17 0 532 23 23 00 0 07 0 05 1 070 301 93 23 60 0 080 00 0 970 821 15 24 20 0 070 05 0 860 880 20 24 80 0 030 08 0 760 48 0 61 25 400 020 08 0 66 0 21 1 00 26 000 060 0511 0 56 0 95 0 86 26 600 070 01 0 46 1 49 0 28 27 200 06 0 04 0 36 1 640 54 27 800 03 0 06 0 25 1 391 29 Show Axes Show Cube Show Data Data scaling Single scale for all data Separate x y z scaling 28 40 0 01 0 07 0 15 0 831 74 29 00 0 05 0 05 0 05 0 171 73 29 60 0 07 0 020 050 361 30 30 20 0 060 020 150 590 61 30 80 0 040 050 250 45 0 09 31 400 000 060 360 00 0 57 32 000 030 050 46 0 58 0 66 32 600 060 020 56 1 10 0 36 33 200 06 0 010 66 1 370 21 33 800 04 0 040 76 1 330 86 34 400 01 0 060 86 0 981 36 35 00 0 02 0 050 97 0 471 53 35 60 0 05 0 031 070 021 34 36 20 0 060 001 170 340 86 36 80 0 040 031 270 370 27 37 40 0 020 051 370 11 0 22 38 000 020 051 47 0 33 0 46 38 600 040 031 58 0 80 0 37 39 200 050 001 68 1 140 02 39 800 04 0 031 78 1 230 55 40 400 02 0 041 88 1 051 04 41 00 0 01 0 051 98 0 681 32 41 60 0 03 0 032 08 0 241 31 42 20 0 05 0 012 190 111 01 42 80 0 040 022 290 250 54 43 40 0 030 042 390 150 07 2 49 0 16 0 25 2 59 0 57 0 31 2 69 0 92 0 09 2 80 1 110 32 2 90 1 060 77 3 00 0 811 12 AllScaling Calculated Angles 0 2122XYZ 43 400Radians0 1920 3840 140 0 138SIN0 1910 3750 139 2 971COS0 9820 9270 990 RotationMatrix Chart Data0 918 0 1290 375 XY0 2070 962 0 177 3 1842 284 3 7011 629X AxisXY 3 7200 162 300 2 754 0 622 3 268 1 5393002 7540 622 2 518 2 892Y AxisXY 1 714 3 4910 300 387 2 886 1 095 3 215030 0 3872 886 0 812 2 236Z AxisXY 0 896 0 93500 3 1 1240 531 1 2550 2360031 124 0 531 1 7150 909Cube FrontXY 2 0850 9103 334 265 2 795 2 2170 3003333 4912 978 2 056 0 664 333 2 0181 733 1 645 1 627 3 33 1 244 4 039 1 109 2 2593 334 265 2 795 0 605 2 366Cube BackXY 0 268 1 939 3 3 3 3 491 2 978 0 170 1 1493 3 32 018 1 733 0 296 0 27833 31 2444 039 0 5600 383 33 3 4 2652 795 0 8320 630 3 3 3 3 491 2 978 0 9890 411Cube Upper Edge LeftXY 0 953 0 167 33 3 4 2652 795 0 714 0 881 333 2 0181 733 0 332 1 476Cube Upper Edge RightXY 0 086 1 74933 31 2444 039 0 430 1 6153333 4912 978 0 617 1 134Cube Lower Edge RightXY 0 624 0 4783 3 32 018 1 733 0 4880 1293 334 265 2 795 0 2930 489Cube Lower Edge LeftXY 0 1410 498 3 3 3 3 491 2 978 0 1140 176 3 33 1 244 4 039 0 246 0 347 0 519 0 876