How to Rotate Forms About the Axes or Origin

Step-by-Step Guide

1. 1

   Step 1: Start by opening a new workbook in Excel from the desktop

   Double click on Excel (either the green X on the dock or the app title in the folder) and select File New Workbook. ,, Doing so will select the entire worksheet.
   
   Format Cells Number Number to decimal places 2, show comma.
   
   Format Cells Alignment Center. # Title the first worksheet, "Rotate Forms" and save the workbook as "Rotate Forms About The Axes"., (By offsetting the circles 180º, they'll be set opposite to one another.) , Select cell range C1:
   C2 and Insert Name Create in Top Row, OK; Select cell range C6:
   C7 and Insert Name Create in Top Row, OK; Select cell range F1:
   G2 and Insert Name Create in Top Row, OK; Select cell range F6:
   G7 and Insert Name Create in Top Row, OK. , This is the square's X sides being created.
   
   Select cell H181 and enter
   2.
   
   Select cell range H91:
   H181 and Edit Fill Series Trend, OK.
   
   Select cell H181 and copy it to cell range H181:
   H271.
   
   Select cell H361 and enter
   0.
   
   Select cell range H271:
   H361 and do Edit Fill Series Trend, OK.
   
   Enter to cell I2 the value, 0, and enter to cell I91 the value,
   2.
   
   Select cell range I2:
   I91 and Edit Fill Series Trend, OK.
   
   This is the square's Y sides being created.
   
   Select cell range I91:
   I181 and Edit Fill Down.
   
   Select cell I271 and enter
   0.
   
   Select cell range I181:
   I271 and do Edit Fill Series Trend, OK.
   
   Select cell I361 and enter
   0.
   
   Select cell range I271:
   I361 and do Edit Fill Down, OK.
   
   Enter to cell J2 the formula, =H2+X2_ADJ Enter to cell K2 the formula, =I2+Y2_ADJ Enter to cell L2 the formula, =COS(Degrees_q*PI()/180)*Adj_Sqr_X+SIN(Degrees_q*PI()/180)*Adj_Sqr_Y Enter to cell M2 the formula, =-SIN(Degrees_q*PI()/180)*Adj_Sqr_X+COS(Degrees_q*PI()/180)*Adj_Sqr_Y Edit Go To J2:
   M362 and do Edit Fill Down. , Add series D2:
   E362, J2:
   K362 and L2:
   M362
   -- NOTE! These may not come out right and may require editing in the formula bar!! Extra series may appear, which must be deleted!! You've been warned.
   
   Edit in the formula bar the series titles in quotes for each series at the front of the series formula.
   
   Pull the Chart Box with the handle that appears when the cursor becomes a double headed arrow over the bottom right corner of the chart, to re-size it so that the circles are nicely true circles, etc.
   
   The example Chart Box has the dimensions Width
   8.45 by Height
   7.86.
   
   Herewith is an image of the final chart (I suggest you match the color of your spreadsheet fonts to the color of the data series for each object). , For more art charts and graphs, you might also want to click on Category:
   Microsoft Excel Imagery, Category:
   Mathematics, Category:
   Spreadsheets or Category:
   Graphics to view many Excel worksheets and charts where Trigonometry, Geometry and Calculus have been turned into Art, or simply click on the category as appears in the upper right white portion of this page, or at the bottom left of the page.
2. 2

   Step 2: from the dock

3. 3

   Step 3: or from within your Applications folder inside the Microsoft folder.

4. 4

   Step 4: In Preferences

5. 5

   Step 5: set R1C1 to unchecked or Off

6. 6

   Step 6: set Ribbon to checked or On and set Show Formula Bar to checked or On.

7. 7

   Step 7: Click in the far upper left top corner above the 1 of row 1 and to the left of column A.

8. 8

   Step 8: Enter the Row 1 and other Column Headers: Enter to cell A1

9. 9

   Step 9: ORIGINAL_X; Enter to cell B1

10. 10

    Step 10: ORIGINAL_Y; Enter to cell C1

11. 11

    Step 11: Degrees_t; Enter to cell D1

12. 12

    Step 12: New x; Enter to cell E1

13. 13

    Step 13: New y; Enter to cell F1

14. 14

    Step 14: X_ADJ; Enter to cell G1

15. 15

    Step 15: Y_ADJ; Enter to cell H1

16. 16

    Step 16: Orig_Sqr_X; Enter to cell I1

17. 17

    Step 17: Orig_Sqr_Y; Enter to cell J1

18. 18

    Step 18: Adj_Sqr_X; Enter to cell K1

19. 19

    Step 19: Adj_Sqr_Y; Enter to cell L1

20. 20

    Step 20: NEW SQR X; Enter to cell M1

21. 21

    Step 21: NEW SQR Y; Enter to cell C6

22. 22

    Step 22: Degrees_q; Enter to cell C7

23. 23

    Step 23: 24; (360º/24º = 15 objects) Enter to cell F6

24. 24

    Step 24: X2_ADJ; Enter to cell F7

25. 25

    Step 25: 4; Enter to cell F8

26. 26

    Step 26: (Square Adjustment) Enter to cell G6

27. 27

    Step 27: Y2_ADJ; Enter to cell G7

28. 28

    Step 28: -6; Enter to cell F2

29. 29

    Step 29: 5; Enter to cell F3

30. 30

    Step 30: (Circle Adjustment) Enter to cell G2

31. 31

    Step 31: 5; Enter to cell C2

32. 32

    Step 32: Define Variable Names: Select columns A

33. 33

    Step 33: J and K and do Insert Names Create in Top Row

34. 34

    Step 34: Enter Column Formulas: Enter to cell A2 the formula

35. 35

    Step 35: =COS((ROW()-2)*PI()/180)+X_ADJ Enter to cell B2 the formula

36. 36

    Step 36: =SIN((ROW()-2)*PI()/180)+Y_ADJ Select cell range A2:B362 and Edit Fill Down; Enter to cell D2 the formula

37. 37

    Step 37: =COS(Degrees_t*PI()/180)*ORIGINAL_X+SIN(Degrees_t*PI()/180)*ORIGINAL_Y Enter to cell E2 the formula

38. 38

    Step 38: =-SIN(Degrees_t*PI()/180)*ORIGINAL_X+COS(Degrees_t*PI()/180)*ORIGINAL_Y Select cell range D2:E362 and Edit Fill Down; Enter to cell H2 the value

39. 39

    Step 39: and select cell range H2:H91 and Edit Fill Down.

40. 40

    Step 40: Create the Chart Objects (4): You should end up with 4 series per your worksheet titled 'Rotate Forms': =SERIES(" ORIGINAL"

41. 41

    Step 41: 'Rotate Forms'!$A$2:$A$362

42. 42

    Step 42: 'Rotate Forms'!$B$2:$B$362

43. 43

    Step 43: 1) =SERIES(" New"

44. 44

    Step 44: 'Rotate Forms'!$D$2:$D$362

45. 45

    Step 45: 'Rotate Forms'!$E$2:$E$362

46. 46

    Step 46: 2) =SERIES(" Adj Square"

47. 47

    Step 47: 'Rotate Forms'!$J$2:$J$362

48. 48

    Step 48: 'Rotate Forms'!$K$2:$K$362

49. 49

    Step 49: 3) =SERIES(" NEW SQUARE"

50. 50

    Step 50: 'Rotate Forms'!$L$2:$L$362

51. 51

    Step 51: 'Rotate Forms'!$M$2:$M$362

52. 52

    Step 52: 4) Select cell range A2:B362 and do Insert Chart or Chart Wizard or use the Ribbon - Charts

53. 53

    Step 53: Scatter

54. 54

    Step 54: Smooth Lined Scatter.

55. 55

    Step 55: Make use of helper articles when proceeding through this tutorial: See the article How to Create a Spirallic Spin Particle Path or Necklace Form or Spherical Border for a list of articles related to Excel

56. 56

    Step 56: Geometric and/or Trigonometric Art

57. 57

    Step 57: Charting/Diagramming and Algebraic Formulation.

Detailed Guide

About the Author