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.
- Skill level:
- Moderately Easy
Other People Are Reading
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for