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:

People Graph 1

 

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

 

Click on the button and a default window appears:People Graph 3

 

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.People Graph 4

 

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

 

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

 

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.People Graph 7

 

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

 

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

 

You may also like...

4 Responses

  1. BENTALEB says:

    please send me people graphe model
    thank’s

  2. Seli Research says:

    Simple to use now for being able to edit font size etc. Will be quite powerful

  3. beatrix says:

    How did you change the number represented by each person? i.e. in the red people graph you had 2.2 people representing 2.2 M but on the yellow people graph you had 22 people represent 2.2 M

  4. melih says:

    Hi,

    If you resize your people graph by dragging from one side and make it narrower It will adjust persons as you mention.

    Best Regads

Leave a Reply

Your email address will not be published. Required fields are marked *