"=IF(OR(AND((ROW()-7)>Rrs*1,(ROW()-7)<=Rrs*2), AND((ROW()-7)>Rrs*3,(ROW()-7)<=Rrs*4), AND((ROW()-7)>Rrs*5,(ROW()-7)<=Rrs*6), AND((ROW()-7)>Rrs*7,(ROW()-7)<=Rrs*8), AND((ROW()-7)>Rrs*9,(ROW()-7)<=Rrs*10), AND((ROW()-7)>Rrs*11,(ROW()-7)<=Rrs*12), AND((ROW()-7)>Rrs*13,(ROW()-7)<=Rrs*14), AND((ROW()-7)>Rrs*15,(ROW()-7)<=Rrs*16), AND((ROW()-7)>Rrs*17,(ROW()-7)<=Rrs*18), AND((ROW()-7)>Rrs*19,(ROW()-7)<=Rrs*20), AND((ROW()-7)>Rrs*21,(ROW()-7)<=Rrs*22), AND((ROW()-7)>Rrs*23,(ROW()-7)<=Rrs*24), AND((ROW()-7)>Rrs*25,(ROW()-7)<=Rrs*26), AND((ROW()-7)>Rrs*27,(ROW()-7)<=Rrs*28), AND((ROW()-7)>Rrs*29,(ROW()-7)<=Rrs*30), AND((ROW()-7)>Rrs*31,(ROW()-7)<=Rrs*32), AND((ROW()-7)>Rrs*33,(ROW()-7)<=Rrs*34), AND((ROW()-7)>Rrs*35,(ROW()-7)<=Rrs*36)),0,1)+On_0_Off_1" and Edit Fill Down to A2886.
Into cell B6 enter 720. Edit Go To cell range B7:B2886 and enter into B7 "=B6-1" w/o quotes and Edit Fill Down.
Into cell C6 enter "=12*PI()*16*103" w/o quotes. Edit Go To cell range C7:C2886 and enter into C7 "=C6-($C$6*2)/ADJROWS" and Edit Fill Down.
Edit Go To cell range D6:D2886 and enter to D6 "=Radius*COS(B6*PI()/180*CircleFactor)" w/o quotes and Edit Fill Down.
Edit Go To cell range E6:E2886 and enter to E6 "=Radius*SIN(B6*PI()/180*CircleFactor)" w/o quotes and Edit Fill Down.
Edit Go To cell range F6:F2886 and enter to F6 "=A6*(SIN(C6/(BASE*2))*FACTOR*COS(C6)*FACTOR)+D6" w/o quotes and Edit Fill Down.
Edit Go To cell range G6:G2886 and enter to G6 "=A6*(SIN(C6/(BASE*2))*FACTOR*SIN(C6)*FACTOR)+E6" w/o quotes and Edit Fill Down.
Edit Go To cell range H6:H2886 and enter to H6 "=ShrinkExpand*(SIN(C6/(BASE*2))*FACTOR*COS(C6)*FACTOR)+ShrinkExpand*D6" w/o quotes and Edit Fill Down.
Edit Go To cell range I6:I2886 and enter to I6 "=ShrinkExpand*(SIN(C6/(BASE*2))*FACTOR*SIN(C6)*FACTOR)+ShrinkExpand*E6" w/o quotes and Edit Fill Down.
Edit Go To cell range J6:J2886 and enter to J6 "=(SIN(C6/(BASE2*2))*FACTOR2*COS(C6)*FACTOR2)+ShrinkExpand2*D6*Radius2/Radius" w/o quotes and Edit Fill Down.
Edit Go To cell range K6:K2886 and enter to K6 "=(SIN(C6/(BASE2*2))*FACTOR2*SIN(C6)*FACTOR2)+ShrinkExpand2*E6*Radius2/Radius" w/o quotes and Edit Fill Down.
Part 2 of 3:
Explanatory Charts, Diagrams, Photos
(dependent upon the tutorial data above)
How to Make Your Excel Curve Solid or Transparent Picture 10
Create the Chart:
Edit Go To cell range F6:G2886 and, using the Chart Wizard if available, else the Ribbon, choose Charts, All/Other, Scatter, Smooth Line Scatter. Copy the chart that appears atop your data and paste it to the Chart worksheet, ow work on the chart that's on your Data worksheet and later copy it to the Chart worksheet. Select Chart Layout and get rid of grid lines, axes and legend. Do Current Selection Plot Area Format Selection. Fill should be Gradient Radial Centered with Red at left 12% and Navy Blue on Right at 52%.
Do Chart Layout Current Selection Series 1 Format Selection. Smoothed Line for Line and Gradient should be Radial Centered Canary Yellow 52%, Red 65%, Midnight Blue from the Color Wheel 82% (just barely effectual/visible), Line Weight should be 20 point ("SOLID"). OK.
Click in the Plot Area and do menu item Chart Add Data and in response to the query, activate the Data worksheet and Edit Go To cell range H6:I2886, OK. This may not come out OK, in which case, edit the series in the Formula Bar until it reads "=SERIES(,Data!$H$6:$H$2886,Data!$I$6:$I$2886,2)" without quotes. Do Chart Layout Series 2 Format Selection. Line is dark blue .5 pt.
Click in the Plot Area and do menu item Chart Add Data and in response to the query, activate the Data worksheet and Edit Go To cell range J6:K2886, OK. This may not come out OK, in which case, edit the series in the Formula Bar until it reads "=SERIES(,Data!$J$6:$J$2886,Data!$K$6:$K$2886,3)" without quotes. Do Chart Layout Series 3 Format Selection. Line is smoothed dark slight charcoal purple .5 pt. lightest DASHED, 2% TRANSPARENT.
Do Chart Layout Chart Area for Current Selection, Format Selection. 3D format is 16 pt Width and Ht bevel and Surface is Metal. Fill is Gradient with (left to right) 0% red, 19% orange, 55% orange, 68% yellow, 74% white, 83% yellow, 91% orange with style Rectangular Direction Upper Left Corner. 0 Transparency.
Here is the finished chart image, with frame:
How to Make Your Excel Curve Solid or Transparent Picture 11
Part 3 of 3:
Helpful Guidance
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.