Create a Diagram, Microsoft Excel

Open Excel.  Click in the gray square above the "1" and to the left of "A".  This will select the entire spreadsheet.  Go to Format, Column, and Width.  Set the width to "2". 

To insert your diagram, go to Format, Sheet, and Background.  Select the picture you want to use as your diagram.  The example shown here is a map, but you could use a drawing of the digestive tract, a diagram of the solar system, etc. This will tile your diagram into the background of the entire spreadsheet.  To hide the adjacent diagrams, select a few columns to the right, go to the paint bucket and select black as the color.  Do the same a few rows below your diagram.  This will black out the adjacent diagrams.  To remove the gridlines, go to Tools, Options, and remove the check beside Gridlines.

Go to a cell in your diagram that you want to label.  Right click that cell and select Insert Comment.  Type in whatever information you want to include.  Click outside that cell, and your comment will disappear and there will be a small red triangle in that cell.  When you move your mouse over the red triangle, the comment will appear.

In the example below, the mouse was moved over the red triangle next to the picture of the pelican.
 


 

GLEs - Math

Grade 5
Data Analysis, Probability, and Discrete Math
30. (D-1-M)

GLEs - English/Language Arts

Grade 5
Information Resources
Standard 5
45. (ELA-5-M3)

Grade 6
Information Resources
Standard 5
46. (ELA-5-M4)

Idea Bank Home | MCS Home