How to Create the Bishop Image in Microsoft Excel

In this article, you'll learn how to create this quick image of a chess piece black Bishop in Microsoft Excel. Become familiar with the image to create: === The Tutorial ===

Part 1 of 3:

The Tutorial

  1. Picture 1 of How to Create the Bishop Image in Microsoft Excel
    Create a new Excel workbook with 3 worksheets: Data, Saves and Chart (unless you are working with Chart Wizard). Select your image you want to make art from trigonometry by -- here, for example, the objective is a black chess bishop. Decide on the basic curve to employ. Here, for example, the curve selected was the spherical helix curve because it stacks nicely like the lathing work on chess pieces, also because of shading considerations it's better than the sine wave  sphere  and finally because of the way spheres are joined, they settle atop one another in a smooth fashion. The basic plan is to select one side of the Square of Spheres previously done in the article How to Make a Square of Spherical Helixes, then to modify the curves of those spheres as if lathing had been applied.
  2. Picture 2 of How to Create the Bishop Image in Microsoft Excel
    Set Your Preferences. Open Preferences in the Excel menu and follow the directions below for each tab/icon.
    1. In General, set R1C1 to Off and select Show the 10 Most Recent Documents .
    2. 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.
    3. 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.
    4. In Chart, allow show chart names and set data markers on hover and leave the rest unchecked for now.
    5. In Calculation, make sure Automatically is checked and "calculate before save" is also checked. Set max change to 0.001 without commas as goal-seeking is not done much. Check save external link values and use 1904 system
    6. In Error checking, check all the options.
    7. In Save, select save preview picture with new files and Save Autorecover after 5 minutes
    8. In Ribbon, keep all of them checked except Hide group titles and Developer.
  3. Picture 3 of How to Create the Bishop Image in Microsoft Excel
    Go to cell A16 and do Freeze Panes. It helps to place the cursor between the A of Column A and the 1 in Row 1 in the upper leftmost corner and select the entire worksheet, then set Format Cells➛Number➛Number Decimal Places to 4 and Font Size at 9 to 12.
  4. Picture 4 of How to Create the Bishop Image in Microsoft Excel
    Enter the upper Defined Name Variables Section (see the picture of the data chit):
    1. In cell A1, enter AdjRows and in cell A2 enter 1439 and format fill it dark green with white font, decimal places 2.
    2. In cell B1, enter GMLL and in cell B2 enter "=-(1-SQRT(5))/2" w/o quotes, decimal places 6.
    3. In cell C1, enter Factor and in cell C2 enter -.25
    4. In cell D1, enter N and in cell D2 enter 1 and format fill yellow.
    5. Select cell range A1:D2 and Insert Name Create Names in Top Row, OK.
    6. In cell G1, enter the note "{0,1} to (0,0}, {(0,0} to {1,0}, {1,0} to {1,1}, {1,1} to {0,1}" w/o quotes.
    7. In cell G2, enter 1 and Format Cell Number Number Custom "p = "0 (including quotes) and Insert Name Define Name p to cell $G$2.
    8. In cell A3, enter -968115 and Format Cell Number Number Custom "top="0 (including quotes) and Insert Name Define Name top to cell $A$3.
    9. In cell B3, enter -25822 and Format Cell Number Number Custom "c_base="0 (including quotes) and Insert Name Define Name c_base to cell $B$3.
    10. In cell C3, enter 36 and Format Cell Number Number Custom "Spheres="0 (including quotes) and Insert Name Define Name Spheres to cell $C$3.
  5. Picture 5 of How to Create the Bishop Image in Microsoft Excel
    Enter the column heading of row 4:
    1. A4: Base t; B4: c; C4: cos; D4: sin; E4: MAIN X and format font red; F4: MAIN Y and format font red; G4: x of p; H4: y of p; I4: BISHOP
  6. Picture 6 of How to Create the Bishop Image in Microsoft Excel
    Enter the Column Formulas:
    1. Enter into A5 "=-Top" w/o quotes and format fill light rose.
    2. Edit Go To cell range A6:A364 and enter into A6 the formula "=(A5+(-Top*2)/(ADJROWS))" w/o quotes and Edit Fill Down.
    3. Enter into B5 "=c_base" w/o quotes and format fill light rose.
    4. Edit Go To cell range B6:B364 and enter into B6 the formula "=B5" w/o quotes and Edit Fill Down.
  7. Picture 7 of How to Create the Bishop Image in Microsoft Excel
    Edit Go To cell range C5:C364 and enter into C5 the formula "=COS((ROW()-5)*PI()/180*FACTOR)" w/o quotes and Edit Fill Down, or you may leave this blank and unused as it is for putting spheres into a ring.
  8. Picture 8 of How to Create the Bishop Image in Microsoft Excel
    Edit Go To cell range C5:C364 and enter into C5 the formula "=SIN((ROW()-5)*PI()/180*FACTOR)" w/o quotes and Edit Fill Down, or you may leave this blank and unused as it is for putting spheres into a ring.
  9. Picture 9 of How to Create the Bishop Image in Microsoft Excel
    Originally, this is a stack of 6 spheres descending from {1,0) to (0,0} over 360 rows, so 360.6 = 60 rows/sphere. Edit Go To cell range E5:F64 and format fill yellow and enter to E5 the formula "=((SIN(A5/(B5*2))*GMLL*COS(A5)*GMLL*(COS(A5/(B5*2))) *GMLL)+G5)^(N-0)" w/o quotes and where the last symbol is zero, not oh. Then tab over to cell F5 and enter the formula "=I5*((SIN(A5/(B5*2))*GMLL*SIN(A5)*GMLL*(COS(A5/(B5*2)))*GMLL) +H5)^(N-0)" w/o quotes, and do Edit Fill Down.
    1. Then the remaining 300 cells or 5 spheres are reversed and the call to column I is on the X side=: Edit Go To E65:F364 and enter to E65 "=I65*((SIN(A65/(B65*2))*GMLL*COS(A65)*GMLL*(COS(A65/(B65*2)))*GMLL)+G65)^(N-0)" w/o quotes, then tab over to F65 and enter "=((SIN(A65/(B65*2))*GMLL*SIN(A65)*GMLL*(COS(A65/(B65*2)))*GMLL)+H65)^(N-0)" w/o quotes and Edit Fill Down. You may wish to follow me and format each 60 row x+y set as a lightly filled different color to tell them apart.
  10. Picture 10 of How to Create the Bishop Image in Microsoft Excel
    Edit Go To cell range G5:G364, enter 0 in G5 and Edit Fill Down.
  11. Picture 11 of How to Create the Bishop Image in Microsoft Excel
    Select H5 and input 1. Edit Go To H6:H364 and enter to H6 the formula "=H5-p/360" and Edit Fill Down.
  12. Picture 12 of How to Create the Bishop Image in Microsoft Excel
    Picture 13 of How to Create the Bishop Image in Microsoft Excel
    BISHOP (from head to toe): Originally, this was to be a queen with a spiked crown but every attempt to achieve that failed so a bishop was settled upon. Enter to I5 1.075 and enter to the cell range I6:I64 1 and Edit Fill Down. Enter 4.5 for cell range I65:I68 via Edit Fill Down. Enter "=PI()" for cell range I69:I73 via Edit Fill Down. Go To cell I125 and enter "=1/-1.33" and select cell range I73:I125 and do Edit Fill Series Column Linear Trend (or possibly Growth Trend -- I forget), OK. Edit Go To cell range I126:I184 and enter "=1/-1.33" and Edit Fill Down. Edit Go To cell range I185:I244 and enter 1.33 and Edit Fill Down. Edit Go To cell range I245:I304 and enter .75 and Edit Fill Down. Edit Go To cell range I305:I355 and enter 2 and Edit Fill Down. Edit Go To cell range I356:I364 and enter "=2*PI()" and Edit Fill Down.

Part 2 of 3:

Explanatory charts, diagrams, and photos

  1. (dependent upon the tutorial data above)
  1. Picture 14 of How to Create the Bishop Image in Microsoft Excel
    Create the Chart:
    1. Edit Go To E5:F364 and select either the Chart Wizard or Chart on the Ribbon, All/Other. Scatter, Smoother Line Scatter. If not in Chart Wizard where a chart is automatically opened, copy or cut the chart from atop the Data worksheet and activate the Chart worksheet and paste it in the upper left corner. Expand it by pulling on the lower right corner by hovering over it until the cursor becomes a double headed arrow and then grabbing the corner and pulling down and to the right to form an approximate square.
    2. Do Chart Layout to remove the Chart Grid Lines, Axes and Legend. At far left under Current Selection, choose Plot Area and beneath that select Format Selection. Do Line No Line. Do Fill Pattern or Texture -Texture White Marble. Do 3D Format Top Circle Width and Height 6 pts each and Depth & Surface - Surface = Dark Edge. OK.
    3. Back under Current Selection, choose Series 1, Format Selection. Do Shadow checked perspective, black, 63% size, all the rest 0's. Angle is 115 degrees quoted and unchangeable.
    4. Line - Smoothed. Gradient (see picture please). Weight = 35 pt. Path states Upper Left Corner (but I don't believe it and didn't select anything) and Gradient from left to right is 15% Very Dark Navy Blue, 41% Black, 48% Charcoal Grey, 52% White, 54% Charcoal Grey, 66% Light Grey, 71% Light (not lightest) Blue, 81% White, 96% Very Dark Navy Blue. Glow is Light Blue at 8pt size and 25% transparency with 4 pt Soft Edges, OK. Effect is to resemble adhesed marble with various light and medium spray glazes.
  2. Picture 15 of How to Create the Bishop Image in Microsoft Excel
    Copy the formulas and paste them to the Saves worksheet down to row 15 and then do it again beneath them, only this time, do Paste Special Values atop the proper formatting. Then, with the Shift key down, Copy Picture, lift the Shift key and select the Saves worksheet, and depress the Shift key and do Paste Picture below the formulas -- that way, you'll have a record of how your settings were when you accomplished the image. If you want, copy the BISHOP column too, for safety's sake, along with the MAIN X and Y columns and x and y of p columns. Fortunately, there aren't all that many rows.
Part 3 of 3:

Helpful Guidance

  1. Make use of helper articles when proceeding through this tutorial:
    1. 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.
    2. 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.
Update 05 March 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile