Creating pictographs with Excel

Ever realized that the expensive copy of Excel which costed you a couple hundred of dollars is capable of creating pictographs (graphs which use pictures to indicate values)? Here, I'm going to teach you how to do it...


(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 ]