HomeApplicationGraphic designHow to Create a Sin and Cos Circle in Excel

How to Create a Sin and Cos Circle in Excel

Part 1 of 3:

The Tutorial

  1. How to Create a Sin and Cos Circle in Excel Picture 1
    Open a new XL workbook from the desktop.
    1. Click on the green X icon on the Dock to make Excel the active application.
    2. Put on the dock with the yellow dot at top left of the window of any XL workbooks automatically opened.
    3. Do File New Workbook from the Excel Menu.
    4. Save the workbook as Circle, or other similar filename, into a logical file folder (if you follow all Xhohx and Christopher G. articles, this is #110, and you may want to create a special folder with an apt name reminiscent of the article name for the folder, beginning with 110 -- in that case, the filename = the article name)(100 for Xhohx, and this is #10 for Christopher G.). That way, you can go into Advanced Editing and make a copy of the text of the entire article for safekeeping by pasting it into Word, under the bolded and linked title.
  2. How to Create a Sin and Cos Circle in Excel Picture 2
    Set the Preferences under the Excel menu:
    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 .001 as goal-seeking is not done in this project. 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. How to Create a Sin and Cos Circle in Excel Picture 3
    Go to cell A2 and do Freeze Panes under the Window menu.
    1. It helps by placing the cursor between the A of Column A and the 1 in Row 1 in the upper leftmost corner and selecting the entire worksheet.
    2. Format Cells Number Number Custom +0.0000;-0.0000;=0.0000, Font Size 9 to 12.
    3. Do Format Cells Alignment Text Alignment Horizontal Center.
  4. How to Create a Sin and Cos Circle in Excel Picture 4
    Input column title labels, defined variable names and variable values in Row 1, and columns E and F:
    1. Enter the label Cos into cell A1;
    2. Enter the label Sin into cell B1;
    3. Enter the label Radius x into cell C1;
    4. Enter the label Radius y into cell D1;
    5. Enter the defined variable name ShrinkExpand into cell E1 and adjust column size to fit;
    6. Enter the defined variable name X Offset into cell E2;
    7. Enter the defined variable name Y Offset into cell E3;
    8. Select range E1:F3 and do Insert Names Create in Right Column;
    9. Enter 2 into cell F1 and enter 2 into cell F2 and enter 2 into cell F3.
    10. Select cell range F1:F3 and do Format Cells Font Red, Fill Yellow, since they're input cells.
  5. How to Create a Sin and Cos Circle in Excel Picture 5
    Enter the formulas for the "3 o'clock" Radius line to appear in the Chart:
    1. Enter to cell C2 the formula, without quotes, "=X_Offset"
    2. Enter to cell D2 the formula, without quotes, "=Y_Offset"
    3. Enter to cell C3 the formula, without quotes, "=C2+ShrinkExpand"
    4. Enter to cell D3 the formula, without quotes, "=D2"
  6. How to Create a Sin and Cos Circle in Excel Picture 6
    Enter the Cosine (x) and Sine (y) formulas and fill down:
    1. Enter to cell A2 the formula, w/o quotes, "=X_Offset+COS((ROW()-2)*PI()/180)*ShrinkExpand"
    2. Enter to cell B2 the formula, w.o quotes, "=Y_Offset+SIN((ROW()-2)*PI()/180)*ShrinkExpand"
    3. Edit Go To cell range A2:B362
    4. Do Edit Fill Down
Part 2 of 3:

Explanatory Charts, Diagrams, Photos

  1. How to Create a Sin and Cos Circle in Excel Picture 7
    Create the Chart:
    1. With cell range A2:B362 still selected, do either Insert Chart or Select Charts from the Ribbon;
    2. Select chart type Scatter, Smooth Line Scatter; a chart should appear on your worksheet.
    3. Name the worksheet, Circle Data and Chart;
    4. Enter to cell D4 the note 'edited chart series' and make it italic and aligned right;
    5. Select cell range C2:D3, do command and c for copy, click inside the circle in the chart and do command and v, paste. This may come out wrong. Click on the line created and edit the Series Formula in the formula bar until it exactly reads as follows (but w/o quotes):
    6. "=SERIES("Radius",'Circle Data and Chart'!$C$2:$C$3,'Circle Data and Chart'!$D$2:$D$3,2)"
    7. Click on the Circle. Its Series Formula should exactly read as follows -- you'll probably have to edit in "Circumference":
    8. "=SERIES("Circumference",'Circle Data and Chart'!$A$2:$A$362,'Circle Data and Chart'!$B$2:$B$362,1)"
    9. Check that your chart looks like the one pictured here.
    10. That's it! You're finished!
  2. How to Create a Sin and Cos Circle in Excel Picture 8
    Further formatting of the chart (optional):
    1. By double-clicking on the Circumference or the Radius, you'll bring up the Format Data Series dialog box, which gives you many options as to the appearance of your final image -- try out different options -- have fun with it!!
    2. You can also tap with the mouse near the outside of the chart, beyond the plotting area, and hold down the Shift Key, and do Edit Copy Picture. Then there are various menu tool formatting options additionally available to you. You would do Shift Key and Paste Picture to a new worksheet called SAVES, or CHARTS, or VIEWS, or something similar.
      How to Create a Sin and Cos Circle in Excel Picture 9
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 that category if it appears in the upper right white portion of this page, or at the bottom left of the page.
4 ★ | 1 Vote
cellenterchartformula

You should read it

May be interested

  • How to Create a Curve in ExcelPhoto of How to Create a Curve in Excel
    you will learn to research and locate a curve of interest, then set up the data for graphing (charting) it in microsoft excel in the following steps. the example curve in the photo from the text was chosen at random from a standard...
  • How to Create an S Curve Pattern in Microsoft ExcelPhoto of How to Create an S Curve Pattern in Microsoft Excel
    in this article, you'll learn to make the 's curve' pattern and image below, and the dozens of variations the file permits therefrom. become familiar with the basic image to be created: === the tutorial ===
  • How to Color Inside the Lines in FireAlpacaPhoto of How to Color Inside the Lines in FireAlpaca
    firealpaca is a free illustration and photo-editing software compatible with both mac and windows. lots of people use this to start out their digital art career or hobby, so it's useful to know all the tools available. coloring inside the...
  • How to Use WeavesilkPhoto of How to Use Weavesilk
    weavesilk, often simply known as silk, is a website that allows users to create colorful digital images on a black background. it can be used for many purposes, such as relieving anxiety, creating profile pictures, or simply just playing...
  • How to Make a MonogramPhoto of How to Make a Monogram
    this article describes how to design a monogram using microsoft word. once you've done that, you can save the monogram as a template or an image for use in other documents, such as invitations or business cards. these steps will work in...
  • How to Acquire the Black Mosaic Tile Image via ExcelPhoto of How to Acquire the Black Mosaic Tile Image via Excel
    learn how to acquire the black mosaic tile image or magic carpet image via excel by following the steps below. become familiar with the basic image to be created: === the tutorial ===

Graphic design