# Step By Step

Document Sample

```					Original   Xcoord      Ycoord       Zcoord                Dervied     Xcoord   Ycoord
One         -8.24696    -6.53817     -7.15736                          12.11696 -3.27755
Two         -4.40407    -8.10153     -0.87647                          5.973822 -2.93826
Three       -3.53771    0.411158     2.211881                          -0.23723 -4.18483
Four        7.113823    9.079351     -7.46994                          -1.06172 9.34146
Five        1.991873    6.413114     7.423237                          -9.32693 -2.28139
Six          7.83326      -5.3228    9.050667                          -8.71994 2.657173
Seven       -9.17224    3.644076     -7.30579                          8.640788 -4.58377
Eight       -5.96562    -4.17276     3.511972                          1.697388 -6.67483
Nine        -4.69659      -1.0058     6.22507                          -2.29236 -7.08502
Ten         0.636617    -3.55633     -2.44688                          3.035299 1.957177

The Green areas are actual original values.
12
The Blue are calculated values used in the chart.
10
The Yellow areas are used in the calculations
8

6

4
Create a xy-scatter based on G2:H11                                 2

0

-15    -10     -5   -2   0             5   10   15

-4

-6

-8

12
Format plot area and set pattern and
10
border to None.
8

Delete legend                                                                 6

4

2

0

-15     -10        -5        -2   0        5

-4

-6

-8

15
Set the X and Y axes to have
minimum=-15                                                                  10
maximum=15
5
The values exceed the actual data and
values used for the dummy axis and cage.                                      0
This is to stop clipping whilst rotating the     -15     -10        -5             0        5

chart                                                                         -5

-10

-15

15
Use Chart Source Data to add 2 new data
series.
Use Chart Source Data to add 2 new data
series.                                                                                              16.5
10
The Axes L26:M33                                                                                     7.12
5
-0.7
and the Cage L56:M74                                                                                 8.63
0                           16.5
-15   -10          -5         0          5           0.79
-5                          -8.6
-16.
-10
-7.1
-15
0.79

-7.1
8.63
Format the new series to have no markers
and borders.                                                                                         -0.7
-16.
Format the actual chart axes to have no
tickmarks, tickmark labels or line                                                                   -8.6
7.12

Finally add text to the points if required.
Add data labels with the show value option.
Four
To get the data labels to display the text you want rather
than the y value do one of the following
Six                          Ten
1. Select a specfic data label and manually edited the text.
Five                               Two
2. Select a specific data label and then go to the formula                                       Three
bar. Either enter the cell address, including the sheet                                       Nine Eight
name, or simply click the required cell.

3. Use one of these free addins to link data lables to cells.
Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)
Calculated Angles
0.798636 -0.78801 0.642788 Sin values
0.601815 0.615661 -0.76604 Cos values

Rotation Matrix
-0.47162 -0.39574 -0.78801
0.868937 -0.05649 -0.49169
0.150067 -0.91662 0.370514

Angle of rotation for chart

X Angle             53
Y Angle            308
Z Angle            140

Axes        X             Y         Z
-10         0         0

Series1
10         0         0

15                                        0       -10        0
0        10        0

0        0        -10
0        0         10

4.716241 -8.68937
-4.71624 8.689366
0        0
3.957396 0.564894
-3.9574 -0.56489
0        0
7.880108 4.916891
-7.88011 -4.91689
10       15

Cage        X             Y         Z
-10        -10       -10
10        -10       -10
10         10       -10
-10         10       -10
-10        -10       -10
-10        -10        10
10        -10        10
10         10        10
-10         10        10
-10        -10        10

10       15
-10        10         10
-10        10        -10

10        10        -10
10        10         10

10        -10        10
10        -10       -10
16.55374   -3.20758
7.121263   14.17115
-0.79353   13.04136
8.638952   -4.33737
16.55374   -3.20758
10       15     0.793529   -13.0414
-8.63895   4.337368
-16.5537   3.207581
-7.12126   -14.1712
0.793529   -13.0414

-7.12126   -14.1712
8.638952   -4.33737

-0.79353 13.04136
-16.5537 3.207581

-8.63895 4.337368
7.121263 14.17115

Two        One
Seven

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 266 posted: 11/15/2008 language: English pages: 4
How are you planning on using Docstoc?