If you know how to present data in an understandable and effective way, you can deliver your message strongly.
For this purpose, one of my favorite things is a PICTOGRAPH and in Excel, creating a pictograph is quite simple and easy.
Today in this post, I’d like to share with you a simple step by step process to create a pictograph in Excel.
Here my idea is to present the number of employees from various age groups in a company.
Now without any further ado, let’s get started.
We have to use below data for this chart, you can download it from here to follow along.
As I said it’s the total employees in a company age wise and we need t present these groups using this chart.
But before we start, we need an icon to use in this chart and you can download it from a free icon site.
Boom! our chart is ready to rock.
Note: There is an option to specify unit/picture for the chart. You can use it if the values per bar in your chart are large (more than 20). The thing is that the picture icons will become smaller with more numbers and this option helps in that case.
You can also use a different picture for different bars, just like I have used in the below chart.
Select each data bar separately and insert a picture one by one for all the bars.
I always love to create interactive charts and for this time I want to convert this PICTOGRAPH into a chart in which we can use data in an dynamic way.
Just like below.
Look at the below data where we have same company’s employees data, but department wise and we need to create a dynamic chart here which we can operate with option button.
You can download this file from here to follow along and now use below steps to create a dynamic pictograph.
Hurry! our dynamic pictograph is here.
Download this sample file from here to learn more.
Pictograph is one of my list of the advanced Excel charts.
The best thing which I like about this chart is we can use any kind of picture in it, there is no limitation about it.
And you don't need to worry about the picture you have added, it remains there in the clip-board.
I'm sure this chart will help you to present your data in a better way.
And now tell one thing.
Have you ever tried to create a chart like this before?
Please share your views with me in the comment section, I'd love to hear from you. And, don't forget to share this tip with your friends, I'm sure they will appreciate it.
More Advanced Charts and Graphs
- Step Chart: A step chart is an advanced version of line chart which make easy to check variation and changes in the trend [...]
- Milestone Chart: It's a simple chart which helps to track stages of a project in a simple and understandable way [...]
- Waffle Chart: You can also call it a square pie chart. It's a simple square with 100 small boxes which [...]
- Tornado Chart: It looks like a tornado where you can compare data for different categories for two different periods [...]
- Gantt Chart: It's one of the most popular charts for project managers to track project with details and [...]
- Bullet Chart: It's a perfect chart to track single point target and achievement, all the step to create it are [...]
- Thermometer Chart: This chart is also perfect for tracking single point target Vs. achievement [...]
- Speed-O-Meter: It's also called gauge chart which you can use in your dashboards to present some specific KPIs [...]
- Population Pyramid: It's a specific chart which you can use to compare population of two different time periods and for [...]
- People Graph: It's just like a pictograph where you can use icons to create a cool info-graphic [...]