Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
10000+ Copies Already Downloaded
In this post, I will show you how to make a pictograph in excel using a bar chart.
My idea to make a pictograph is to present the number of employees in various age groups in a company. I am just trying to click an idea to use a picture in a chart to make it more meaningful.
But, you can use this technique in your own way. And, please share your views with me.
I am using following data to create a pictograph. Data represents the age group of employees in a department. You can download it from here to follow along.
Before starting to create this you need an icon to use in this chart, you can download it from a free icon site.
And, your final chart will look something like this. Well, I have used option buttons with it to make an interactive chart.
So let’s get started & just follow these simple steps to create this pictogram in excel.
You can also use a different image in your pictograph for each bar. In the chart below, I have used different pictures to represent women and men.
For applying different picture for each bar all you have to do, just select single bar first then insert an image and then do the same for next bar.
The bottom line about pictograph is you can create some awesome visuals about data with inserting a pictures. To make a pictograph in excel you just need a right situation.
Apart from its limited use, it has a cool look. But, one thing you have to take care, don’t do it over. A user is more concerned about the numbers of your chart, not with the pictures.
Now the ball is in your court. Tell me what do you think about it. Have you ever did a pictograph? Or you didn’t know about a pictograph before reading this post.