Web Site Example

Creating pictographs with Excel

What is a Pictograph?
A pictograph or pictogram is a drawing or picture that represents a word, sound or idea. The classic example would be ancient Egyptian hieroglyphs. But pictographs can also be used to represent numerical data in a statistical or financial graph, with each value represented by a proportional number or size of pictures. Rather than use shading to show the size of categories on a bar graph, photographic fills or stacked clip art can form the columns or rows. 

With Excel you can create graphs which use pictures to indicate values.

Steps: Creating pictographs


EXAMPLE :


(Note : This table is formatted by ©Edwin's Power Tools -- EPT 3D Format)

The above table shows the number of chickens each person has got. Firstly, draw a histogram of the above numbers using Excel's built-in Chart Wizard.

In step 2 of the Chart Wizard, choose "Column" charts.

In step 3 of the Chart Wizard, choose the chart type number 8. Click FINISH.


Next, insert a picture of a chicken. (You can use Copy & Paste, or Insert Picture command)

With the chicken picture selected, choose COPY from the Edit menu. Then, double-click the chart to activate it. Click on one of the bars in the chart to select a bar. (may take serveral trials)

With a bar selected, choose PASTE from the Edit menu to paste the chicken into the bar.

Double-click the bar with the chicken, and a dialogbox appears as the one shown below. Choose the "Stack and Scale to:" option button. Input a number (in this example, 5) of units/picture. Click OK.

Finally, paste the chicken picture into each bar by using the PASTE command...

Your pictogram is done!! In case your pictures look a bit skewed, resize the chart to restore their shapes. The finished chart is as show below :

Note that Excel is capable of displaying half chicken or any proportion of the chicken when necessary.


Download the chicken in this tuitorial :
(right-click and choose "save link as" to download the images!)


©1996, Edwin H.B. TAM All rights reserved

[ Back to HOME ]