How to Insert Drawing Objects into your Excel Spreadsheets Microsoft Excel 2013 Tutorial
Visualizing data is always helpful to understand big amount of data in a very short time, and it makes data interesting to read. You can add different shapes, lines etc to illustrate your data in an interesting manner.
In our first example we will illustrate how to calculate cosine of triangle. We have to give it hypotenuse and Adjacent. And it will calculate cosine for us.
We will illustrate it with shapes.
Step 1: To insert a shape in your excel spreadsheet, click on INSERT and locate shapes panel.
Step 2: From all the shapes, Under the Basic Shapes, choose Right Triangle.
Step 3: Click and hold your mouse button, and draw a decent size triangle. Something like shown in image below.
Step 4: You can use rotation handle to rotate the triangle.
Step 5: When you have clicked on triangle you will see Format Tab in ribbon, where you can see various options including colors to fill in the shape.
Step 6: Now add a textbox in your spreadsheet. Click on INSERT tab and locate Textbox on right side as shown in image below.
Step 7: By clicking anywhere on spreadsheet, a text box will appear. You can add text in that textbox and format that text accordingly. After some formatting we get following format of spreadsheet.
Step 8: Now we have to apply formula. Formula of calculating the cosine is following.
=DEGREES(COS(Adjacent_Cell_Reference / Hypotenuse_ Cell_Reference))
Step 9: Select the cell where we want to show our calculated results and paste this formula. In our example it is cell G25 (green color) and we have to pass cell references for Hypotenuse and Adjacent.
Step 10: Formula’s final shape will be
=DEGREES(COS(G12 / G22))
Step 11: And after putting values in cell G12 and G22 our result will show up in cell G25 but in better manner.
Step 12: You can represent your data in way in which it will be more readable and interesting. Use from many other shapes.