Pictograph Chart in Excel – Usage, Making, Formatting

Pictograph Chart in Excel is a useful chart for visually representing the real-world object count. There is no pre-existing chart type for the Pictograph chart. Since this is one of the advanced excel charts, we can make it by using the Bar Chart in Excel. Let us see how the chart works.

What is a Pictograph Chart in Excel?

A Pictograph chart uses small icons to define the magnitude of values of real-world entities like males, females, employees, students, etc. Those icons are chosen on the basis of the category they represent. For instance, look at the following pictograph chart for the employees of a company belonging to different age group categories.

example of a pictograph chart in Excel

So you can see here that each person icon is representing one person. Therefore there are twelve icons in the first topmost bar since there are twelve employees in the age group of 50-60.

This is how we read a Pictograph chart. Now let us start making one!

infographics Pictograph Chart in Excel

Making a Pictograph Chart in Excel

Let us suppose we have the sales of different fruits of a City Mall as follows:-

making a pictograph chart in excel raw data

Inserting the Bar Chart

We will start making the pictograph chart by first inserting a Bar Chart from the above range of cells A1:B10

inserting a bar chart in excel

This will insert the bar chart as shown in the Preview.

Adding icons to the Bar Chart

Adding icons to the inserted bar chart will make it convert into a Pictograph Chart. All you need to do is:-

  • Select the Bar for Melons on the chart and press the ctrl 1 key. Make sure that not all bars are selected.
  • From the Format Data Point pane, set the Bar Fill to Picture or texture fill. Click on the Insert button below the Picture Source field. You can add the picture and there are four options for it.
  • We are inserting an icon for melons in the Online Picture utility.
making a pictograph chart in excel step 2
  • Mark the option for Stack and Scale with. You can also change the value of units one icon represents from the Units/Picture option if required. This is how our chart looks after inserting the melons:-
making a pictograph chart in excel step 3

Similarly, we can add icons for other fruit categories to get the chart.

making a pictograph chart in excel step 4

We have deleted the Gridlines and Horizontal Axis by simply selecting and pressing the delete key.

We can even add data labels to make the chart more readable as follows:-

making a pictograph chart in excel step 5

Example 2 – Pictograph Chart in Excel

Let us say we have the number of Male and Female Staff in a School as follows:-

example 2 inserting a pictograph chart in excel

We will insert the Bar chart from this data and then add the desired icon for males and females to get the resultant chart:-

example 2 inserting a pictograph chart in excel result

In the above chart, we have changed the chart background color to light green. To change the chart background:-

  • Select the entire chart and go to the Format tab on the ribbon.
  • Go to the Shape Styles Group and set the Shape Fill and Border color. Add the desired shadow effect also.
example 2 inserting a pictograph chart in excel step 2

Consequently, this brings us to the end of the blog.

Thank you for reading.

Leave a Comment