How to Create a Flower Pattern in Microsoft Excel

Step-by-Step Guide

1. 1

   Step 1: In the previous article

   This will be a continuation from that article, so please complete that one first. ,, Please copy cell A7 to cell C3.
   
   Make sure that cell C3 has the Defined Variable Name top.
   
   Change the formula in A7 to "=IF(EVEN(S_COUNT)=S_COUNT,ROUND(TOP,0),0)".
   
   Select both cells A7 and C3 using the Command Key and Format (both) Cells Fill Purple, Border Red bold Outline, Font bold, Align horizontal center, Number Number  Decimal Places
   4.
   
   The formula in cell C3 should be "=ROUND((-A4*PI())+(Adj),0)" and the result should be
   968133.0000 (for now). ,, (It's no longer squared). ,,, This will result in a #NAME error which will soon be gone. , Select cell range L2:
   L1441 and input 1 and then do Edit Fill Series Columns Linear Step Value 1 OK.
   
   Enter 72 into cell M1 and
   -440 into cell M2 and select cell range M2:
   M1441 and do Edit Fill Series Column Linear Step Value 72, OK.
   
   Select cell range L2:
   M1441 and Insert Name Define TURNS_LOOKUP to cell range $L$2:$M$1441 and Format Cells Border Blue bold Outline. , Edit Go To cell range O2:
   O1442 and enter
   -1440 and do Edit Fill Series Column Linear Step Value 1, OK.
   
   Edit select cell P1442 and enter the formula "=M2-$M$1".
   
   Go To cell P1441 and enter the formula w/o quotes "=P1442-$M$1" and copy that cell and paste it to cell range P1440:
   P2.
   
   Edit Go To cell range O2:
   P1442 and Insert Name Define Name TURNS_LOOKUP_NEG to cell range $O$2:$P$1442 and Format Cells Border Red bold Outline. , sometimes manually, sometimes automatically, per the differences column appearing in column T at right: and continue at 300 rate until the end, and then do:
   Edit Go To cell range R2:
   S1441 and Insert Name Define name SPHEROIDS_COUNT_LOOKER to cell range $R$2:$S$1441 and Format Cells Border Red bold Outline. ,, See Warnings section below on how to go about doing so if having trouble. , Select cell range E7:
   F1446 and do Chart Wizard and follow along or choose Charts on the Ribbon and select All/Other and scroll down to Scatter, Smoothed Line Scatter, and a new small chart should appear atop your data.
   
   Copy or Cut and Paste it to the Chart worksheet cell A1 and hover over the lower right corner until the cursor becomes a double-headed arrow then click and expand it it open.
   
   Do Chart Layout Format Selection at far left and choose Series 1, Line Weight 1, Color Blueish Purple, and then click on the Plot Area and Format Selection Fill Solid Black.
   
   Select series G7:
   H1446 and I7:
   J1446 and copy and paste those into the chart and correct the data series and get rid of any extra straight lines that appear.
   
   The correct series appear below.
   
   Select the on the Data sheet I7:
   J1446 and make the Line Weight 1 and color Ice Blue.
   
   Select the on the Data sheet G7:
   H1446 and make the Line Weight 1 and color Reddish Brown.
   
   Then change the series order of how the three series display until you have it so that =SERIES(,Data!$G$7:$G$1446,Data!$H$7:$H$1446,1) is Series 1 via the 1 at the very end of the series description; =SERIES(,Data!$I$7:$I$1446,Data!$J$7:$J$1446,2) is Series 2; =SERIES(,Data!$E$7:$E$1446,Data!$F$7:$F$1446,3) is Series
   3. , Save the Workbook and you're done! SPCL DESIGN 02 , 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: How to Create Artistic Patterns in Microsoft Excel

3. 3

   Step 3: a Data worksheet was described in great detail.

4. 4

   Step 4: Start a new workbook by saving the old workbook under a new name.

5. 5

   Step 5: The defined variable "top" is being moved and its formula is being changed

6. 6

   Step 6: to start with.

7. 7

   Step 7: The notes in cells E3:E5 have changed a bit; E3: Put "Y" for Spheres / Spheroids proportionally

8. 8

   Step 8: whether even/odd S_COUNT (in B1) E4:  For S_COUNT (B1) > 25

9. 9

   Step 9: overlapping = "Y" input

10. 10

    Step 10: otherwise input "N" E5: Also: "N" input results in full circle of spheroids / podoids whether odd or even. 

11. 11

    Step 11: Edit Go To cell range D7:D1447 and with D7 active input w/o quotes the formula "=SIN((ROW()-7)*Factor*PI()/180)" and Edit Fill Down.

12. 12

    Step 12: Edit Go To cell range E7:E1447 and input w/o quotes the formula "=(PI())*((SIN(A7/(B7*2))*1*COS(A7)*1*(COS(A7/(B7*2)))*1)+C7)*SIN(A7/(B7*2))" and Edit Fill Down.

13. 13

    Step 13: Edit Go To cell range F7:F1447 and input w/o quotes the formula "=(PI())*((SIN(A7/(B7*2))*1*SIN(A7)*1*(COS(A7/(B7*2)))*1)+D7)*SIN(A7/(B7*2))" and Edit Fill Down.

14. 14

    Step 14: Select cell A5 and enter w/o quotes the formula "=IF(TURNS>0

15. 15

    Step 15: VLOOKUP(TURNS

16. 16

    Step 16: TURNS_LOOKUP

17. 17

    Step 17: VLOOKUP(TURNS

18. 18

    Step 18: TURNS_LOOKUP_NEG

19. 19

    Step 19: Cell L1 should read TURNS_LOOKUP

20. 20

    Step 20: else enter it.

21. 21

    Step 21: Select cell O1 and enter TURNS_LOOKUP_NEG.

22. 22

    Step 22: Copy from the following pictures the cell range R1:S1441.

23. 23

    Step 23: Select cell B2 and enter the formula w/o quotes "=VLOOKUP(S_COUNT

24. 24

    Step 24: SPHEROIDS_COUNT_LOOKER

25. 25

    Step 25: Look for errors and correct any that appear.

26. 26

    Step 26: Create the Chart.

27. 27

    Step 27: Holding the shift key down

28. 28

    Step 28: Copy Picture and activate the Saves worksheet and Paste Picture.

29. 29

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

30. 30

    Step 30: Geometric and/or Trigonometric Art

31. 31

    Step 31: Charting/Diagramming and Algebraic Formulation.

Detailed Guide

About the Author