I have been always fascinated with 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’s called: People Graph
It was first introduced with Microsoft Excel 2013 to help people to create infographics. In a people graph, instead of a column, bar, or line, we have icons to present the data. And, it looks nice and professional.
Today, in this post, I’d like to share simple steps to insert a people graph in Excel and the option which we can use with it. So let’s get started.
7 Steps to Insert a People Graph in Excel
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.
- First of all, go to Insert Tab -> Add-Ins -> click on the small green button.
- It will insert a people graph with dummy data.
- Now, your next step is to connect data with the chart.
- Click on data icon and then click on select your data button.
- Now, select the data table and click on create button.
- The last thing is to all a title for your chart.
- Again click on the data icon and change the default title to the desired title.
Congratulations! Your first info-graphic is ready to tell its story. It’s a proud moment.
Customization and Other Options
As I said it’s easy to insert a people graph. But, there are some customization options that can do after that.
1. Chart Type
There are 3 pre-defined charts types that we can use. Click on the setting button and select the type which you want.
2. Theme
We can also use different themes for our chart. There are 7 pre-defined themes that we can use. Click on the setting button and select the type which you want.
3. Shape (Icon)
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 the shape which you want.
4. Save as Image
There is an option to save it as an image. With this, we can use it further in PowerPoint, send it in an email, upload it to the web, etc.
5. More
- When you update any value in the source data, make sure to click on the graph once to update it.
- You can also paste it as an image in the worksheet by copy paste.
Conclusion
Infographics are superb in presenting data in a vivid way. And I believe that creating a people graph in Excel is really fun.
You can also use it in your dashboards and templates to give them an awesome look and for an effective way to 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?
Please share your views in the comment section, I would love to hear from you. And, don’t forget to share this charting tip with your friends.
More Charting Tips and Tutorials
- How to Add a Horizontal Line in a Chart in Excel
- How to Add a Vertical Line in a Chart in Excel
- How to Create a Bullet Chart in Excel
- How to Create a Dynamic Chart Range in Excel
- How to Create a Dynamic Chart Title in Excel
- How to Create Interactive Charts In Excel
- How to Create a Sales Funnel Chart in Excel
- How to Create a HEAT MAP in Excel
- How to Create a HISTOGRAM in Excel
- How to Create a Pictograph in Excel
- How to Create a Milestone Chart in Excel
- How to Create PIVOT CHART in Excel
- How to Create a Population Pyramid Chart in Excel
- How to Create a SPEEDOMETER Chart [Gauge] in Excel
- How to Create a Step Chart in Excel
- How to Create a Thermometer Chart in Excel
- How to Create a Tornado Chart in Excel
- How to Create Waffle Chart in Excel
Thanks for giving most useful information.
The people graph is a great tool. Will you be able to use more than two columns to tell you story?
Thanks
Hi Puneet,
How do it format the labels on the People graph. When I choose a particular type the labels for the age group I want to make it ‘ bold’. How do I do that.
Thanks for sharing.
I’m afraid that there’s no option that can help you to customize this chart because it’s more of a add-in. But here’s the link to create a pictograph where you can add an icon in the chart to and make all the customization that you need.
https://excelchamps.com/excel-charts/pictograph/
take care
Hello Puneet
Please do you have an idea about people graph.
someone sent me this “I have a question regarding Microsoft People Graph and installing it for a small group of users. Looks like it trying to do centralized deployment of the app”
How is it possibele to use this chart in a vba makro? Our figures are not getting updated.
During a VBA makro the data is not updated in the graph – how can I achieve this?
There is a limitation of using this people graph, it is not showing the data more than 15 rows and I am unable to see the full graph even 10 rows are, it is displaying only 4 rows.
How can you get the images to represent a smaller population? I am trying to represent pregnancies per 1000 and it wants to represent per 10 not per 1.
can’t seem to find the link to download the data table
In the first of the seven steps you say, “Here is the data table …”. that is NOT a data table. It is not even, formally, a table. It’s a list or a range. At best it’s a frequency distribution table.
Thanks for correcting me.
Dear Puneet, Thanks for Sharing People Graph. I have never use this type of graph. Thanks
There’s always something new to learn, Imran.
Hi Puneet,
That’s great and useful for me the people graph. But for me the Green People graph was not highlighted.
Please help me how to get it.
You mean green icons and black background.
Yes….. I am using excel 2016 please suggest me how to get that icon highlighted
@narmadabachoti:disqus Please share a snap-shot
https://uploads.disquscdn.com/images/c4dde740a88a8bdd2888619b1194e39b8b8d5fce217f898ed14353d849b654ef.png
Use this link to reinstall ==> https://store.office.com/en-us/app.aspx?ui=en-US&rs=en-US&ad=US&assetid=WA104104476&appredirect=false