How to Acquire Slant Parabolas in Excel

Step-by-Step Guide

1. 1

   Step 1: Take the familiar equation y = Kx^2 and rotate it about the origin.

   Diagram of Rotation about the Origin.
2. 2

   Step 2: Do this by making a substitution of two new variables (X and Y) using equations like this: x = cos(t)*X + sin(t)*Y y = -sin(t)*X + cos(t)*Y where sin and cos are the sine and cosine functions from trigonometry

   , 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., The cell beneath it will become the Defined Named Variable Factor1, which will be used to factor the parabola's size of the x coordinate, eg. if you want to cut all the x values in half, you would enter .5 into cell A2; Enter to cell B1 the label, Factor2.
   
   This will be used to factor the y coordinates.
   
   Enter to cell C1 the label, ParaVertex X.
   
   Used to control the vertex.
   
   Enter to cell D1 the label, ParaVertex Y.
   
   Also used to control the vertex.
   
   Select cell range A1:
   D2 and Insert Name Create Names in Top Row.
   
   This will assign the labels as Defined Variable Names to the cells A2 to D2.
   
   Enter to cell A2 the value, 1; Enter to cell B2 the value, 1; Enter to cell C2 the value, 5; Enter to cell D2 the formula, =5+5-1.79; (w/o the ending semi-colon) , This will create the defined variable name K for cell G4, which can now be used in a formula.
   
   Select cell G4 and enter the value 5 into it. ,, Do Charts, All, Scatter, Smooth Lined Scatter.
   
   A chart will appear atop your worksheet.
   
   Drag it off to the right just past the data, out of the way, then hover over the bottom right corner until the cursor turns into a double-headed arrow, then pull the chart down and to the right to expand it.
   
   Your chart should show a very thin parabola, like the fiber of an iris muscle of the eye somewhat, extending from about {5,5} down to {253.10,
   -158.31} on the left branch and to {253.10,
   -158.65} on the right branch.
   
   It's good that it's so thin, but it's much too long in the x direction to use within our eye & iris chart; we need to factor the x coordinate by
   253.1*n = 6 or so, so n = 6/253.1
   -- perform that computation by entering it below the data as =6/253.1, and then copy it and paste it to cell A2; Now the parabola is still slanted, which is what you want, and which is dependent on both the size and plus or minus status of angle t and value K ... but it is now too wide open, and the vertex has shifted from where it's being reported at {5, 5} slightly; By taking the total difference of the max and min of the y values in column B, i.e.
   5.93-
   -2.61, you arrive at a total height of the curve of
   8.55; you want it to be more like .55, so you create another little formula algebraically to adjust Factor2, which is .55 = n*8.55, so you enter =.55/8.55 into cell B2; The curve still displays as wide, but that's because Excel shortened the y scale range of the chart dramatically.
   
   Click on the vertical axis and set the maximum to 10 and the minimum to
   0.0
   -- there now, that's better.
   
   And the iris fiber extends out to the right about 5 units.
   
   But its vertex has moved up to {5, 8} and you want it more like {5, 5} (we can be more exacting later), so you need to subtract 3 from ParaVertex_Y in cell D2
   -- do so now.
   
   OK! Success! That's beginning to look like where you want to begin your iris fibers! Try doubling the angle t to 80
   -- see how thin it gets? You would think that, since 80 degrees is twice the angle that 40 degrees is, the opposite effect would have occurred, but now try half of 40, 20 for angle t in cell C4.
   
   It widens the parabola instead of thinning it.
   
   The reason for that is all the constraints we've put on the curve in this author's opinion.
   
   Nor is the curve any longer at much of a slant, but falls pretty much along the x axis.
   
   Clearly, this is going to take some tinkering with to be useful but there it is, in the rough, the slant parabola.
   
   Change K to .09 and watch the X scale become a great deal shorter in fact.
   
   This means you are now capable of creating "cascading parabolas"
   
   though not yet in a fractal, multiple way.
   
   That will come with the next article, hopefully! Enjoy! ,, 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.
3. 3

   Step 3: and t is the angle by which you are rotating the parabola

4. 4

   Step 4: and where you'll let X and Y vary between -5 and 5

5. 5

   Step 5: being sure that 0 is one of the values as well.

6. 6

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

7. 7

   Step 7: from the dock

8. 8

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

9. 9

   Step 9: In Preferences

10. 10

    Step 10: set R1C1 to unchecked or Off

11. 11

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

12. 12

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

13. 13

    Step 13: Enter the Row 1 Column Headers: Enter to cell A1 the label

14. 14

    Step 14: Factor1.

15. 15

    Step 15: Enter the Row 3 Column Headers: Enter to cell A3 the label

16. 16

    Step 16: Chart x; Enter to cell B3 the label

17. 17

    Step 17: Chart y; Enter to cell C3 the label

18. 18

    Step 18: angle t; Enter to cell D3 the label

19. 19

    Step 19: cos(t); Enter to cell E3 the label

20. 20

    Step 20: sin(t); Enter to cell F3 the label

21. 21

    Step 21: X and Y Series and Format Column Autofit Selection; Enter to cell G3 the label

22. 22

    Step 22: K. Select cell range G3:G4 and do Insert Name Create in Top Row.

23. 23

    Step 23: Enter the formulas and series for the short data section to be charted: Enter to cell A4 the formula

24. 24

    Step 24: =ParaVertex_X+Factor1*K*((D4*F4)+(E4*F4))^2; do Format Cells Fill Yellow and copy it and paste it to cell A5; Enter to cell B4 the formula

25. 25

    Step 25: =ParaVertex_Y+Factor2*((-E4*A4)+D4*F4); do Format Cells Fill Yellow and copy it and paste it to cell B5; the minus sign is important -- please don't miss it; Enter to cell C4 the value 40 and enter to cell C5 the formula

26. 26

    Step 26: =C4; Enter to cell D4 the formula

27. 27

    Step 27: =COS(C4*PI()/180); Enter to cell E4 the formula

28. 28

    Step 28: =SIN(C4*PI()/180); Copy cell range D4:E4 and paste it to cell range D5:E5; Enter to cell F4 the value -5; Do Edit Fill Series

29. 29

    Step 29: accept the default Step Value of 1

30. 30

    Step 30: for cell range F4:F14 -- you should have the value 0.00 in cell F9 and the value 5.00 in cell F14; Copy cell range A5:E5 and Paste it to cell range A6:E14.

31. 31

    Step 31: Select cell range A4:B14 and do either Insert Chart or from the Ribbon

32. 32

    Step 32: select Chart

33. 33

    Step 33: or do Chart Wizard.

34. 34

    Step 34: Try the following changes to angle t

35. 35

    Step 35: by manually inputting them: Angle t Manually Changed to adjust Curve Smoothness.jpg Here's an image of the data chit of the worksheet just completed (and including the Tips below): Here's an image of the chart where we just ended up

36. 36

    Step 36: after adjusting Curve Smoothness: Here's a data chit with another series added

37. 37

    Step 37: for making two parabolas on the chart (it uses the Angle t to vary the curve): Here's a chart of the two parabolas

38. 38

    Step 38: one more curvy

39. 39

    Step 39: the other more slanted (the red is the lower data

40. 40

    Step 40: the blue is the upper data):

41. 41

    Step 41: 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

42. 42

    Step 42: Geometric and/or Trigonometric Art

43. 43

    Step 43: Charting/Diagramming and Algebraic Formulation.

Detailed Guide

About the Author