Excel People Graph

Most people are not aware of the nice tool named People Graph that become available with Excel 2013. It allows you create fancy charts fit for infographics.

It is very easy to create a people graph with Excel.  I looks really nice and professional. But it is a one dimensional chart that can only show one column of data. And it only works in Excel 2013 and later.

You can get this app from store link located under Insert Tab.

Here is a step by step guide for creating a People Graph:

Have your data arranged in two columns:

You can find People Graph under insert tab, inside add-ins group.

Click on the button and a default window appears:

Notice two buttons on upper right corner of the screen. The one on the left (looks like a table) is Data button and the one on the right (cog) is Settings button. When you press Data button, a menu will slide in from right.

Input graph title inside the text box below the green button and press “Select your data” button to select your data.

You will receive an information note regarding your selection based on the charts limitations:

Press Create button and your People Graph will be created with default styling options.

Now it is time for some formatting. Click on the Settings button (Cog on the upper right corner). Settings menu will slide in from right.

You can play with settings to fit your chart to your liking. After a couple of clicks mine looks like this:

Data used for this graph is taken from: https://en.wikipedia.org/wiki/List_of_religious_populations