People Graph

People Graph is a cool app for Office that transforms your cold data to vivid pictures. The new release includes eight new shapes, simplified data binding, and added new notifications and error handling.

Most people are not aware of the nice tool named People Graph that become available with Excel 2013 and later versions. It is very easy to create a people graph with Excel.  It looks really nice and professional. But it is a one dimensional chart that can only show one column of data.

 

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

 Install the People Graph app for Office

  1. Sign in to Office 2013 with your Microsoft Account
  2. Open Excel 2013 and choose INSERT > Apps for Office.

3.      Choose FEATURED APPS, search “People Graph”, and then choose Add.

  1. Choose Trust It.

Chart types

People Graph app includes three chart types.

Chart themes

For each chart type, there are seven themes to choose.

Chart themes

For each chart type, there are seven themes to choose.

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

  1. Have your data arranged in two columns.
  2. You can find People Graph under insert tab, inside add-ins group.
  3. 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.

  1. Input graph title inside the text box below the green button and press “Select your data” button to select your data.
  2. 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.
  3. Now you can change the formatting by Click on the Settings button (Cog on the upper right corner).