# How to Create a Floral Glassware Pattern in Microsoft Excel

Four Parts:Previous Lessons LearnedThe TutorialExplanatory Charts, Diagrams, PhotosHelpful Guidance

In this article, you'll learn to make the "floral glassware" pattern and image below, and the dozens of variations the file permits therefrom.

### Part 1 Previous Lessons Learned

- 1
**This article relies on the previous accomplishment of the 6 articles preceding it:** - 2
**Please complete those first before attempting this one.**

### Part 2 The Tutorial

- 1
**Start a new workbook by saving the previous workbook under a new name.**Save the workbook into a logical file folder. - 2
**Complete all changes in the upper Defined Variables section.**- Enter On=0,Off=1 cell A4 = 1
- Enter Adjuster = 1
- Enter TURNS = 9
- Enter S's Count = 4
- Enter Var = "=IF(S_COUNT<4,S_COUNT+30,12)"
- Enter Divisor = 3.0
- Enter top = "=ROUND((-B4*PI())+(Adj),0)" 968061
- Enter YN = Y
- Enter Power = 15. Insert New Comment "Try 1500^.5".
- All the rest are the same as they were before.

- 3
**Complete all changes in the upper Columnar Formulas section.**- c = -152,555 as the result of "=ROUND(-EXP((PI()^2)+(Cc*-(db))),0)+Designer"
- Enter to D7:D1447 w/ D7 active "=X7/Divisor+IF(COS((ROW()-7)*PI()/180*Factor)<0,ABS(COS((ROW()-7)*PI()/180*Factor))^Power*-1,COS((ROW()-7)*PI()/180*Factor)^Power)"
- Enter to E7:E1447 w/ E7 active "=Y7/Divisor+IF(SIN((ROW()-7)*PI()/180*Factor)<0,ABS(SIN((ROW()-7)*PI()/180*Factor))^Power*-1,SIN((ROW()-7)*PI()/180*Factor)^Power)"
- The External Ring and GMLL x,y and GMSL x,y formulas are unchanged. All other formulas and lookup tables are unchanged.
- Enter 1's Sequence to cell AB6 and Format Font Underline.

### Part 3 Explanatory Charts, Diagrams, Photos

- 1
**Create the Chart (dependent upon the tutorial data above).**- Edit Go To cell range F7:G1446 on the Data worksheet and using Chart Wizard or the Ribbon, select Charts All/Other, Scatter, Smoothed Line Scatter. Copy the Chart to the Chart worksheet and expand it with the double-headed arrow via the bottom right corner.
- Select Chart Layout and get rid of the axes and grid lines and legend; select Data Series 1.
- Format Selection Line Weight 2, Solid Color Wheel Color Deep Purple, Transparency 0%.
- Select Plot Area and Format Selection Line - No Line, Fill-- Radial 4 colors: Left to Right: 1) Grey blend to 5/8 marker 2) Cerulean blue, then 3) tightly packed Navy blue, then last quarter = 4) Light Sky Blue.
- Glow - Dark Blue but not Navy Blue, Size 32 pt, Transparency 78%, Soft Edges 7 pt.
- 3-D Format - Surface: Translucent Powder, no Bevel.
- Select Chart Area and Format Selection:
- Fill Solid Navy Blue, Line - No Line, Shadow - Outer 315 degrees black Size 334 Blur 4 Pt Distance 30 pt Transparency 11%; Glow & Soft Edges - No, 3-D Format - None.

- 2
**But there's no reason to go with my hippie tastes!**Format the chart as you please! Done! - 3
**Copy the live formulas and Paste Special Values then too to Saves, then Do Copy Picture and Paste Picture from the Chart with the Shift Key depressed to Saves and Save the workbook.**Do so for each modification in the Tips section below. -

### Part 4 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

- Try these variable settings for some more cool images!
- S_Count = 1, Divisor = pi:
- S_Count = .5, Divisor = pi:
- S_Count = 31/32 = .96875, Divisor = pi:
- S_Count=2, db=1, Divisor=6, Var=12, Power=0:
- TURNS=10, S_COUNT=25, VAR=12, db=1, Divisor=25, Power=2:
- TURNS=2, S_COUNT=25, VAR=12, db=1, Divisor=25, Power=2:
- TURNS=2, S_COUNT=25, VAR=12, db=1, Divisor=25, Power=4/3 w. marker style square dot size 3:

## Warnings

- ERRORS: If there are errors or error values, either the sheet in incomplete and needs further input or Lookup Tables for critical variables or perhaps there's 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 there is a #DIV/0! error, the example does not, so look for a variable that somehow did not get filled in with a value perhaps. At any rate, what 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 the worksheet, one 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 the 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 rescaling 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 source file for this article is "Garthwaite LINE10a.xlsx"

## Article Info

Categories: Graphics | Microsoft Excel