trustmeasfrnd
New Member
- Joined
- Oct 19, 2008
- Messages
- 32
i ve a circle with 18 nodes and i want to plot it in excel may be using chart.it can be done.
now suppose i plotted a circle of diameter 2m then i have 18 nodes equally divided on its perimeter.what if i want to reduce the circle diameter to 1.8m how to generate its coordinate any easy way to do this?
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
thanks and regards,
abhisekh
now suppose i plotted a circle of diameter 2m then i have 18 nodes equally divided on its perimeter.what if i want to reduce the circle diameter to 1.8m how to generate its coordinate any easy way to do this?
A | B | C | D | |
---|---|---|---|---|
1 | node number | x | y | z |
2 | 100 | -1 | 3 | 0 |
3 | 101 | -0.9397 | 3 | -0.342 |
4 | 102 | -0.766 | 3 | -0.6428 |
5 | 103 | -0.5 | 3 | -0.866 |
6 | 104 | -0.1736 | 3 | -0.9848 |
7 | 105 | 0.1736 | 3 | -0.9848 |
8 | 106 | 0.5 | 3 | -0.866 |
9 | 107 | 0.766 | 3 | -0.6428 |
10 | 108 | 0.9397 | 3 | -0.342 |
11 | 109 | 1 | 3 | 0 |
12 | 110 | 0.9397 | 3 | 0.342 |
13 | 111 | 0.766 | 3 | 0.6428 |
14 | 112 | 0.5 | 3 | 0.866 |
15 | 113 | 0.1736 | 3 | 0.9848 |
16 | 114 | -0.1736 | 3 | 0.9848 |
17 | 115 | -0.5 | 3 | 0.866 |
18 | 116 | -0.766 | 3 | 0.6428 |
19 | 117 | -0.9397 | 3 | 0.342 |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
thanks and regards,
abhisekh