How to Make a Pictograph in Excel

1. Open Microsoft Excel
2. Create a BAR or COLUMN graph – Use the “How to Make a Graph in Excel” worksheet if needed
3. Be sure the handles on the graph are turned OFF
4. Insert a picture
   1. Go to INSERT, PICTURE, CLIP ART
   2. Type in a search word and find a picture to use
   3. Click on the picture to insert it
   4. Move the picture so it is not blocking the graph
5. Click on the picture.  Go to EDIT, COPY
6. Click on any bar on the graph – all the bars should get a “dot” on them
7. Click EDIT, PASTE – each bar should change to the picture
8. Double click on any bar – the “Format Data Series” box should appear
   1. Be sure the “Patterns” tab is clicked at the top
   2. Click on the “Fill Effects” button on the right side – the “Fill Effects” box should appear
   3. On the bottom left, click on the button called “Stack and Scale to”
   4. Be sure the scale number is 1

                                                               i.      This means each picture is one thing (example:1 glass of lemonade)

                                                             ii.      If the number is 2, then each picture means two things (example: 2 glasses of lemonade) and so on

                                                            iii.      Check with your teacher before using any number except 1

5. Click OK
8. Close the “Format Data Series” box
9. Your graph is now a Pictograph

NOTE: To see the graph better (and to print the graph) click on the graph to show the handles, and go to FILE, PRINT PREVIEW.