Create a Pictograph in Excel

A pictograph uses pictures to represent numerical data in a chart or graph. Unlike standard diagrams, a pictograph incorporates pictures to replace the colored columns or bars most often seen in presentations, grabbing your audience’s interest through the use of color and images. 

Make your next presentation more interesting and easier to understand by incorporating a pictograph in Excel. 

from http://www.inbox.com/article/how-do-create-pictograph-in-excel-2010.html

In a pictograph, pictures replace the colored columns or bars in a regular column chart or bar graph. This tutorial covers how to change a simple bar graph to a pictograph in Microsoft Excel .

Related tutorial: Create a Pictograph in Excel 2003

The steps of the tutorial are:

  • Step 1: Create a bar graph in Excel
     
  • Step 2: Select a single data series in the graph
     
  • Step 3: Adding a Picture to the Pictograph
     
  • Step 4: Tutorial Data
01
of 04

Pictograph Example Step 1: Create a Bar Graph

Create a Pictograph in Excel
Create a Pictograph in Excel. © Ted French
  1. To complete this step by step tutorial, add the data found in step 4 to an Excel 2007 spreadsheet.
     
  2. Drag select cells A2 to D5.
     
  3. On the ribbon, choose Insert > Column > 2-d Clustered Column.

A basic column chart is created and placed on your worksheet.

02
of 04

Pictograph Example Step 2: Select a Single Data Series

Create a Pictograph in Excel
Create a Pictograph in Excel. © Ted French

For help with this step, see the image above.

To create a pictograph you need to substitute a picture file for the current colored fill of each data bar in the graph.

  1. Right-click on one of the blue data bars in the graph and choose Format Data Series from the context menu.
     
  2. The above step opens the Format Data Series dialog box.
03
of 04

Pictograph Example Step 3: Adding a Picture to the Pictograph

Create a Pictograph in Excel
Create a Pictograph in Excel. © Ted French

For help with this step, see the image above.

In the Format Data Series dialog box opened in step 2:

  1. Click on the Fill options in the left-hand window to access the available fill options.
     
  2. In the right-hand window, click on the Picture or texture fill option.
     
  3. Click on the Clip Art button to open the Select Picture window.
     
  4. Type "cookie" in the Search Text box and press the Go button to see the available clip art pictures.
     
  5. Click on a picture from those available and press the OK button to select it.
     
  6. Click on the Stack option below the clip art button.
     
  7. Press the Close button at the bottom of the dialog box to return to your graph.
     
  8. The blue colored bars in the graph should have been replaced with the cookie image selected.
     
  9. Repeat the above steps to change the other bars in the graph to pictures.
     
  10. Once completed, your pictograph should resemble the example on page 1 of this tutorial.
04
of 04

Tutorial Data

Create a Pictograph in Excel
Create a Pictograph in Excel. © Ted French

To follow this tutorial, add the above data to an Excel spreadsheet starting in cell A3.

Was this page helpful?