# How to Create Artistic Patterns in Microsoft Excel

Three Parts:The TutorialExplanatory Charts, Diagrams, PhotosHelpful Guidance

Have you ever wanted to **create special designs and patterns**? This article will show you how you can make cool patterns using Microsoft Excel. It's followed by 14 more articles of artistic designs that build from this beginning.

## Steps

### Part 1 The Tutorial

- 1
Name them Data, Chart (unless you're using Chart Wizard) and Saves. Save the workbook into a folder with a name you can easily remember.

Open a new Excel workbook and create 3 worksheets. - 2
**Set Your Preferences:**Open Preferences in the Excel menu and follow the directions below for each tab.- In General, set
*R1C1*to Off and select*Show the 10 Most Recent Documents*. - In Edit, set all the first options to checked except
*Automatically Convert Date System*. Set*Display number of decimal places*to blank(as integers are preferred). Preserve the display of dates and set 30 for 21st century cutoff. - In View, click on show
*Formula Bar*and*Status Bar*and hover for*comments of all Objects*. Check*Show grid lines*and set all boxes below that to auto or checked. - In Chart, allow
*show chart names*and set*data markers*on hover and leave the rest unchecked for now. - In Calculation, Make sure
*Automatically*and*calculate before save*is checked. Set max change to .000,000,000,000,01 without commas as goal-seeking is done a lot. Check*save external link values*and*use 1904 system* - In Error checking, check all the options.
- In Save, select s
*ave preview picture with new files*and*Save Auto-recover*after 5 minutes - In Ribbon, keep all of them checked except
*Hide group titles*and*Developer*.

- In General, set
- 3
**Select the Data worksheet and input the row 1 Defined Variables and Formatting.**- A1: 1.000 000 007 w/o spaces and Format Cells Number Number Custom "Adjuster" 0.000 000 000 (with quotes and w/o spaces). This number is very sensitive to extremely small changes. The image at top is with setting = 1. Format Cells Fill Light Yellow and Font Orange.
- B1: 8 and Format Cells Number Number Custom "S's Count" 0 (for Spheroids Count originally) and Format Cells Fill Green and Font Black Bold. Insert Name Define name S_COUNT to cell $B$1.
- C1: "GMSL = " w/o quotes and aligned right.
- D1: 0.381 966 011 250 105 w/o spaces between decimals. Insert Name Define name GMSL to cell $D$1.
- G1: .94 and Format Cells Number Number Custom "Sync1 ".0000 and Fill Light Yellow and Border Black bold Outline.
- H1: "<=INPUT=> " w/o quotes. and alignment Horizontal Center.
- I1: .88 and Format Cells Number Number Custom "Sync2 ".0000 and Fill Light Yellow and Border Black bold Outline.

- 4
**Input the row 2 Defined Variables and Formatting.**- A2: 31 and Format Cells Number Number Custom "TURNS "+0;"TURNS "-0 and Format Cells Fill Canary Yellow and Font Blue and Insert Name Define Name TURNS to cell $A$2.
- B2: -50,100 and Format Cells Number Number Custom "Designer "+0;"Designer"-0;"Zero Tolerated"+0. Insert Name Define name Designer to cell $B$2 and Format Font Italic.
- C2: "GMLL = " w/o quotes and aligned right.
- D2: 0.618 033 988 749 895 w/o spaces between decimals. Insert Name Define name GMLL to cell $D$2.
- F2: Sync1 and Sync2: in red font and aligned right.
- G2: Input the formula w/o quotes "=G1/GMLL" and Insert Name Define name Sync1 to cell $G$2 and Format Cells Fill Color Blue and Font Dark Blue.
- H2: "<=Let Calc=> "
- I2: Input the formula w/o quotes "=I1/GMSL" and Insert Name Define name Sync2 to cell $I$2 and Format Cells Fill Color Blue and Font Dark Blue.

- 5
**Input the row 3 Defined Variables and Formatting.**- A3: 1439 and Format Cells Number Number Custom "AdjRows "0 and align right. Insert Name Define Name AdjRows to cell $A$3.
- B3: 12 and Format Cells Number Number Custom "Var" +0.000000;"Var" -0.000000

- 6
**Input the row 4 Defined Variables and Formatting.**- A4: -308.100 and Format Cells Number Number Custom "t" +0.0000;"t" -0.0000 and align right.
- B4: Input the formula w/o quotes "=-0.25*PI()/B3" and Format Cells Number Number Custom"Cc" +0.00000000;"Cc" -0.00000000 and align right and Insert Name Define Name Cc to cell $B$4.
- D4: Y and Format Cells font red and Border Double Line Red Outline and here is the image if N is selected:
- E4 Align left the following message in red font: "Input Y or N: If Y and cell B1 Input < 24 and Even, Factor variable will be proportioned"
- E5 Align left the rest of the message: "so that the Spheroids are more spherical in a partial Circle and less elongated/podoid."

- 7
**Input the row 5 Defined Variables and Formatting.**- A5: Enter the formula w/o quotes "=VLOOKUP(TURNS,TURNS_LOOKUP,2)" and format italic and align right.
- B5: 4.5 and Format Cells Number Number Custom "db" +0.00000000;"db" -0.00000000 and Insert Name Define name db to cell $B$5.
- C5: Enter the formula w/o quotes "=ABS(Factor/0.25)" and Format Cells Number Number Percent 2 decimal places and align right.
- D5: Enter the formula w/o quotes "=IF(AND(S_COUNT

- 8
**Enter the TURNS_LOOKUP table.**- Select cell L1 and enter TURNS_LOOKUP
- Enter 1 into cell L2 and Edit Go To cell range L2:L121 and Edit Fill Series Columns Linear Step Value 1 OK.
- Select cell M10 and enter 190. Format font red.
- Select cell range M2:M9 and with M2 the active cell, enter the formula w/o quotes "=M3-70" and Edit Fill Down. Select cell range M11:M121 and with M11 the active cell, enter w/o quotes the formula "=M10+70" and Edit Fill Down.
- Edit Go To cell range L2:M121 and Insert Name Define Name TURNS_LOOKUP to cell range $L$2:$M$121.

- 9
**There was an old Lookup Table that was used, SPHEROIDS_COUNT_LOOKER, but it's so inexact and lengthy to impart that it will be included as a table in the Tips section.**It can be used with the Designer cell as the following formula: "=VLOOKUP(S_COUNT,SPHEROIDS_COUNT_LOOKER,2)". - 10
**Enter the column headings of row 6.**- A6: t; B6: c; C6: Cos X; D6: Sin Y; E6: External Ring X; F6: External Ring Y; G6: GMLL x; H6 GMLL y; I6: GMSL x; J6: GMSL y.

- 11
**Input the columnar formulas:**- A7: Enter the formula w/o quotes "=ROUND((-A4*PI())+(Adj),0)" and format bold and align right and Insert Name Define Name top to cell A7. Format Cells Number Number Custom "top" 0.0000 -- the result should be 969655
- Edit Go To cell range A8:A1447 and with A8 active input w/o quotes the formula "=((A7+(-top*2)/(AdjRows)))*$A$1" and Edit Fill Down. The result in cell A1446 should be 969655.0068
- Edit Go To cell B7 and enter w/o quotes the formula "=ROUND(-EXP((PI()^2)+(Cc*-(db))),0)+Designer" -- the result should be -76055
- Edit Go To cell range B8:B1447 and enter "=B7" and Edit Fill Down.
- Edit Go To cell range C7:C1447 and enter "=COS((ROW()-7)*Factor*PI()/180)" and Edit Fill Down.
- Edit Go To cell range D7:D1447 and enter "=SIN((ROW()-7)*PI()/180)^2" and Edit Fill Down -- do not miss the fact that it's squared compared to the cosine. It's a nice chart either way.
- Edit Go To cell range E7:E1447 and enter "=PI()*(((SIN(A7/(B7*2))*GMLL*COS(A7)*GMLL*(COS(A7/(B7*2)))*GMLL)+C7))" and Edit Fill Down.
- Edit Go To cell range F7:F1447 and enter "=PI()*((SIN(A7/(B7*2))*GMLL*SIN(A7)*GMLL*(COS(A7/(B7*2)))*GMLL)+D7)" and Edit Fill Down.
- Edit Go To cell range G7:G1447 and enter "=E7*GMLL*Sync1" and Edit Fill Down.
- Edit Go To cell range H7:H1447 and enter "=F7*GMLL*Sync1" and Edit Fill Down.
- Edit Go To cell range I7:I1447 and enter "=E7*GMSL*Sync2" and Edit Fill Down.
- Edit Go To cell range J7:J1447 and enter "=F7*GMSL*Sync2" and Edit Fill Down.

- 12
**The top and bottom rows should look like this:**

### Part 2 Explanatory Charts, Diagrams, Photos

- (dependent upon the tutorial data above)

- 1
**Create the Chart:**- Edit Go To cell range E7:F1447 and if you're using Chart Wizard, follow along, else go on the Ribbon to Charts, All/Other, Scroll Down to Scatter, Smoothed Line Scatter and a small chart should appear atop your data. Cut or Copy and Paste it to The Chart worksheet A1 cell and hover over the bottom right corner until the cursor becomes the double-headed arrow and expand the chart to about L49. Select the Chart Frame and set it to No line and Fill No Fill. Select the Plot Series and double click it or go to chart Layout and select it from Format Selection and do Line Weigh 1 and Color from the Color Wheel Hot Pink. Click on the Plot Area and do Format Selection at the far left of Chart Layout and set Fill to Gradient Rectangular Centered Black gradient 90% and white for the right selector for the outside edge.
- Edit Go To cell range G7:H1447 back on the Data worksheet and copy it and paste it directly into the chart. It may come out wrong and the series may have to be edited in the formula bar until it reads: "=SERIES(,'Data'!$G$7:$G$1447,'Dara'!$H$7:$H$1447,2)". Double-click on the data-series or Format Selection via the Chart Layout option and set line weight 1 and color sky blue.
- Edit Go To cell range I7:J1447 back on the Data worksheet and copy it and paste it directly into the chart. It may come out wrong and the series may have to be edited in the formula bar until it reads: "=SERIES(,'Data'!$I$7:$I$1447,'Data'!$J$7:$J$1447,3)". Double-click on the data-series or Format Selection via the Chart Layout option and set line weight 1 and color off white Ta Dah! You're done!

- 2
**Go to the data worksheet so you can save the original values and settings and column widths, etc.**onto the Saves worksheet as both formulas and pasted Values. Hold down the shift key and do command+c Copy the chart and activate the Saves worksheet and Paste Picture. Now you're done. - 3
**The worksheet contains many interesting designs, so feel free to explore the various variables.**If one is a scientist, one keeps notes, and so one should consider Insert New Comment for every Original formula, so one can easily backtrack in case of blunder. Save the workbook and you're finished! - 4

### Part 3 Helpful Guidance

- 1
**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, Geometric and/or Trigonometric Art, Charting/Diagramming and Algebraic Formulation.
- 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.

## Tips

- Here is the SPHEROIDS_COUNT_LOOKER table, in case you want to use it in connection with the Designer cell and the following formula: "=VLOOKUP(S_COUNT,SPHEROIDS_COUNT_LOOKER,2)"; as you can see, on the left hand side is at first a fill series between 0 and 1 and then another series with step value 1.

## Warnings

- ERRORS: If you have errors or error values, either the sheet in incomplete and needs further input or Lookup Tables for critical variables or perhaps you've made a mistake somewhere along the line. If the instructions have been completed and there are still errors, select the cell that has the error value that is furthest left and topmost first. Look for a typo in a formula or unmatched parentheses. Possibly, a Defined Name is wrong -- they need to be input into the formulas exactly as they were defined. Do Insert Name Define to check. If you have DIV/0!, I do not, so look for a variable that somehow did not get filled in with a value perhaps. At any rate, what you want to do is select the cell with the error, and after checking all those typical errors, do Tools Auditing Trace Precedents and/or Trace Error. If fixing all the topmost leftmost errors does not fix the rest of your errors on your worksheet, you may need to do it the hard way, from the bottom right upwards then leftwards; that is the slow but sure way to fix all errors.
- Also, errors in your chart data will most likely plot as zeroes. This may be acceptable or desirable even. However, if too many lines (or curves) are returning to 0, it may indicate a logical flaw in the data -- or too many tiny values and then perhaps re-scaling the chart is needed by inspecting the horizontal and vertical axes and changing them to zero in on the problem. Hover over or click on a data marker on the series plot and then do a search in the proper column by value for that value, and identify its precedents.

## Sources and Citations

- The file used to create this article was "Garthwaite Line01.xlsx"

## Article Info

Categories: Graphics | Microsoft Excel Imagery