Curriculum Area:
English/ Mathematics/ Studies of Society and
Environment/ Science
Grade Level:
Yrs
2 and up
Application:
Microsoft Excel 2002
Tip:
Change a plain chart into a fancy pictograph in Excel.
Description:
After creating a plain Excel chart, students see how fancy, yet meaningful, it can become by
changing it into a pictograph. A pictograph is a graph that uses pictures to show and compare
information
Sample Pictograph:
How To:
- After creating a spreadsheet to represent your data, create a bar chart. Don't format it yet--you can do that after you change the chart to a pictograph.
-
Review your chart, and decide whether you want to use the same picture for all
the bars or different pictures for each bar.
IMPORTANT: You need to have a picture file on your drive in order to create a pictograph.
If you want to use the same picture for all bars:
- Double-click one of the bars, and in the Format Data Series
dialog box, click Fill Effects on the Patterns tab.
- In the Fill Effects dialog box, on the Picture
tab, click Select Picture, and then select a picture from your
folder or network drive. Click the Insert button.
- On the Picture tab, in the Format section,
select Stretch, Stack, or Stack and scale to. Click OK when you're finished. Click OK again to see your bars change to pictures.
If you want to use a different picture for each bar:
- Click once on one of the bars, and then click once again on the bar
that you would like to change to a picture (you'll see selection boxes around
just this one bar). Double-click this bar, and then click Fill Effects
on the Patterns tab.
- In the Fill Effects dialog box, on the Picture
tab, click Select Picture, and then select a picture from your folder
or network drive. Click the Insert button.
- On the Picture tab, in the Format section,
select Stretch, Stack, or Stack and scale to.
Click OK when you're finished. Click OK again to see just
the one bar change to the picture that you selected.
- Repeat steps a-c to apply pictures to the other bars.
More Ideas:
Try saving pictures from Web sites to use in your pictographs.
Check out Microsoft's online gallery for pictures, Design Gallery Live, at
http://dgl.microsoft.com/.
|
|
© 2003 Microsoft Corporation. All rights reserved. Microsoft, Microsoft Press, FrontPage, Access, Outlook, PowerPoint, Visio and Windows Media, MapPoint, SharePoint are registered trademarks of Microsoft Corporation in the United States and/or other countries.
|