How to Make a Pictograph on Excel
Microsoft Excel 2010 can create a pictograph that replaces the bars on a standard graph with tiled or scaled images. Replacing the abstract bars on a graph with pictures of real-life items may help an audience better relate to your data. Create a pictograph using Excel's "Picture or Texture Fill" feature.
Other People Are Reading
Instructions
-
-
1
Launch Excel 2010 and open a spreadsheet containing data that can be expressed in a graph. Highlight the cells that you want Excel to include in the graph.
-
2
Select the "Insert" tab at the top of the window. Click "Column" or "Bar" in the "Charts" section of the toolbar to generate a graph from the selected data.
-
-
3
Double-click one of the graph's bars. This opens a Format Data Point window.
-
4
Select the "Fill" heading on the left side of the Format Data Point window.
-
5
Click to select the "Picture or Texture Fill" radio button.
-
6
Click the "File" button under "Insert from" and double-click the image you want to use for the selected bar.
-
7
Click the "Stack" radio button to display several stacked copies of the selected image in place of the bar, or click the "Stretch" radio button to display a single image stretched to fill the bar.
-
8
Click "OK" and repeat Steps 3 through 7 for the remaining bars of the graph.
-
1
