Pictogram in Excel (Mac version)

(This tutorial used Mac Excel 2011. If you're using Excel for Windows, click here for the Windows version tutorial.)

Not a lot of Excel users know that Excel is capable of plotting pictograms, like the one shown below. (Cute, right?) It is in fact a bar chart (histogram), which also presents the values in terms of picture count. Let me walk you through how to do this pictogram. :D


Step 1: Prepare the Data

Prepare a rectangular range of data. Like this one shown in the picture below. 2 columns, each column must have a column heading.


Step 2: Plot the Bar Chart

In the "Charts" tab of the ribbon, click the "Column" button, and then choose the first icon ("Clustered Column"). (Don't worry about the name of those chart types. I'm sure even most of the people at Microsoft don't know what they mean from the names.)

Step 2: Format the Bars

  1. Use the mouse to right-click any of the bars in the chart, and choose "Format Data Series".
    You'll then see a form like this:

  2. Click "Fill" on the left, and choose "Picture or Texture" on right top.
  3. Then, click "Choose File" to browse for your picture file. (Suggest to use square pictures.)
  4. Choose the "Stack and Scale with" option, and type a number to define the "Units per Picture". 50 in this example.