Now the specified data series is filled with corresponding pictures as the below screenshot shown.Ĩ. Click to select the Stack and Scale with option in the Format Data Series pane. In the following Insert Picture window, find and select the corresponding picture you have saved in step 1 and then click the Insert button.ħ. In the Insert Pictures dialog, click From a File.Ħ. In the Format Data Series pane, you need to configure as follows. Select a data bar in the chart (here I select the Apple series), right click it and select Format Data Series from the right-clicking menu.Ĥ. Select the data range you will create graph by, go to the Insert tab, and then click Insert Column or Bar Chart > Clustered Column. Before creating the pictograph, you need to save corresponding pictures to represent the objects in your computer.Ģ.
Please do as follows to make a pictograph in Excel.ġ. This tutorial provides a step-by-step guide for you to easily create a pictograph in Excel. Normally, when creating a graph in Excel, you can use pictures to represent objects instead of bars or lines to make the graph more understandable. How to make a pictograph (chart with pictures) in Excel?
