How to Create a Pictograph in Excel

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.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Based in New York, Kate Bluest has been writing for various online publications since 2005. She has participated in several writing workshops, including the MIT Writing Workshop. Bluest holds a Bachelor of Science in business administration from SUNY Empire State College.