What is a pictogram? It is a graph that makes use of images to represent data. It is actually represented in the same way as a bar chart, but instead of bars, it uses images to display the data. Precisely in this article, we are going to see how we can create a pictograph in Microsoft Excelwe will notice that it is something very easy to achieve.
Despite the fact that there are free alternatives to Office, we cannot deny that the Microsoft suite is the one that enjoys the greatest number of functions and features. Although some versions are a security risk, it is an application that cannot be missing from our computer.
Create a pictogram in Excel
We start by opening Microsoft Excel and entering data into a sheet or using an existing one. We will have to click on the Insert tab, then we will click on Bar Chart and we will choose the stacked bar in the 2-D section.
We will see that the bar graph appears in the spreadsheet. Now we are going to have to replace the bars and insert images into the chart.
We will right-click on any of the bars in the chart and choose Format Data Series from the context menu.
- We’ll click on the Fill & Line tab.
- Next, in the Fill section, we will click on Fill with image or texture.
- Under Image Source, click Insert.
- An Insert Image window opens and we choose images online.
- We can choose, for example, an apple. We typed it into the search engine.
- We choose the apple and click on Insert.
What we are going to notice in the bar graph is that the images are stretched and only show one apple for each one.
In order to solve this problem, we will click on Stock and scale with. Next, we’ll click the Series Options tab and change the gap width to 0%.
Now we are going to notice that the apple in the graph looks perfectly, we close the panel and we have already managed to create a pictogram in Excel.
Remember that if you have any questions, you can leave it in the comment box that you will find a little further down and we will be happy to help you solve it.