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.
Worth $20, Absolutely Free
I have been always fascinated about info graphics and story based visuals. These kinds of things help me to tell a story with data.
A pictograph is a great example of this. But apart from this, there is a chart in Excel about which most of us are not aware.
That is called: People Graph. It was first introduced with Excel 2013 by Microsoft to help people to create info graphics.
In a people graph, instead of column, bar or a line, we have icons to present the data. And, it looks nice and professional.
So today, in this post, I’d like share with simple steps to insert a people graph in Excel and the option which we can use with it.
So let’s get started.
Creating a people graph in Excel is simple and easy, we just need few clicks. Here is the data table which I’m using here, you can download it from here to follow along.
Congratulations! Your first info-graphic is ready to tell its story. It’s a proud moment.
As I said it’s easy to insert a people graph. But, there some customization options which can do after that.
There are 3 pre-defined charts types which we can use. Click on the setting button and select a type which you want.
We can also use different themes for our chart. There are 7 pre-defined themes which we can use. Click on the setting button and select a type which you want.
We can’t use a single shape for all types of data. So that’s why there are 12 different shapes from which we can select. Click on the setting button and select a shape which you want.
There is an option to save it as an image. With this, we can use it further in PowerPoint, sent it in an email, upload to the web, etc.
Info graphics are superb in presenting data in a vivid way. And I believe that creating a people graph in Excel is a real fun.
You can also use it in your dashboards and templates to give them an awesome look and for an effective way make others understand data.
I’m sure you found this graph useful and it will help you in your work.
Now tell me one thing. Have you ever tried this before? And do you think we can use it in our dashboards? Share your views in the comment section, I would love to hear from you.
And, please don’t forget to share this charting tip with your friends.