How to Create a Pictograph in Excel

Written by kate bluest | 13/05/2017
How to Create a Pictograph in Excel
A pictograph replaces the standard bars with images you select. (Hemera Technologies/ Images)

In Excel, you can go beyond creating a graph and create a pictograph to make your graph stand out. A pictograph is a graph that uses images to represent figures instead of the standard graph visual representations of your data. You can edit all visual elements of the graph. The types of graphs most appropriate for creating a pictograph are column, pie, bar, area, doughnut and bubble graphs.

Open Microsoft Excel, and enter the data for your chart. Select the data, and click the "Insert" tab. Select a chart that is conducive to adding images.

Select the data section in the chart (In a bar graph, the data sections are the bars). To add the same image to all of the data sections at once, select all of the data sections. To add different images to different data sections, select the specific data section to which you would like to add an image.

Right-click on the selected data section, and select "Format Data Point" to open the "Format Data Point" dialogue box.

Click "Fill" in the left menu of the "Format Data Point." Select the "Picture or texture fill" radio button in the "Fill" window. Click the "File" or "Clip Art" button to select the image. Select the "Stretch," "Stack" or "Stack and Scale radio button. Choose your "Stretch options." If you want the image to be transparent, use the sliding scale to set the transparency of the image. Click "Close" to return to the spreadsheet.

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.