Make sure that you have the picture you are going to use already saved in a place that can be easily accessed. It should be simple and preferably in a vector format, such as WMF.
Excel can also do pictograms, although it is a little more complicated.
Create a pictogram from this data:
| City | Mean hours of sunshine in June |
| Alphaville | 7 |
| Betatown | 10 |
| Gammaby | 6 |
| Fineborough | 2 |
Make sure that you have the picture you are going to use already saved in a place that can be easily accessed. It should be simple and preferably in a vector format, such as WMF.
Enter the data into Excel.
Select the data and start the Chart Wizard.
Choose 'Bar' as the chart type and 'Clustered Bar' as the sub-type then click 'Next', then 'Finish'.
You now have a bar chart.
We need to turn it into a pictogram. Double-click on one of the bars. You should see the 'Format Data Series' box. Make sure the 'Patterns' tab is showing and click on 'Fill Effects...'.
Go to the 'Picture' tab and click 'Select Picture...'
Locate the picture you want and click 'Insert'.
In the 'Format' section make sure that 'Stack and scale to:' is selected and, since we want each picture to stand for 2 hours, enter 2 for 'Units/Picture'.
Click on 'OK' twice and admire your pictogram.
We can make it look better with a bit of tweaking...
The grey background doesn't look too good, so double-click on the grey background to bring up the 'Format Plot Area' box. In the 'Area' section select 'None' and click 'OK'.
We want to get rid of the grid lines so click on one of the grid lines so they are selected, then right-click and select 'Clear'.
We want to have a proper key, so right-click on a blank area of the chart and select 'Source Data...' Go to the 'Series' tab and change the Name to ="= 2 hours".
Click on 'OK' to confirm your choice.
Finally we want to have a proper title. Right-click on a blank area of the chart and select 'Chart Options...'
On the 'Titles' tab change the chart title to something suitable. Press 'OK' to complete your chart.
