How to Create a People Graph in Excel

If you take advantage of Excel’s charts for helpful visual displays of your data, check out the People Graph option to create a simple depiction of the number of people or items you have logged in your spreadsheet.

Excel Header

RAYMOND OGLESBY @RaymondOglesby2
September 9, 2021

If you take advantage of Excel’s charts for helpful visual displays of your data, check out the People Graph option to create a simple depiction of the number of people or items you have logged in your spreadsheet.

This is for devices running Excel. Screenshots are from Excel for Office 365 and Windows 10.

Dilbert and Lunch
Copyright Scott Adams, Inc./Distributed by Universal Uclick for UFS

You can display things like the number of visitors to your website, downloads of your app, sign-ups for your event, calls to your support center, and much more.

Add People Graph Add-In

People Graph is an Add-In developed by Microsoft, and there’s already a button for it in your Excel ribbon. But before you can use it, you will have to trust the add-in to install it. First, open the Insert tab in Excel and look for the Add-ins group. Click the button for People Graph. Refer to below image:

Graph 1
Select the Add-In

Next, You will see a pop-up window with a link to See Details. This takes you to the Add-In on the Office Store, where you can read an overview, reviews, and other details. Click Trust this add-in to get started. See below image:

Graph 2
Trust the Add-In option

Now, once the add-in is installed in Excel, you can click the button on the Insert tab to use the feature.

Insert a People Graph

Whenever you hit the People Graph button in the ribbon, you will see a sample graph. First. click the Data icon that looks like a small grid. See following image:

Graph 3
Select the People Graph button

Optionally, you can enter your graph Title before selecting your data, or you can just head back to this spot to add the title later. Next, click Select your data, and then drag through the cells that you want to use. Currently, you must use two columns of data, but you can have multiple rows. Refer to below image:

Graph 4
Select your data

Now, click Create on the People Graph screen. See below image:

Graph 5
Create the People Graph

Customize Your People Graph

First, click the gear icon to open the Settings. You can then move through the three settings for type, theme, and shape. See following image;

Graph 6
Select the Settings gear icon

You can currently pick from three graph types. Each has a slightly different layout and appearance. Now, click Type, and then choose one on the right side. Refer to below image:

Graph 7
Select your Type of graph

Next, you can select a Theme that changes the background and colors of your graph. Click Theme, and choose one of the seven options. See below image:

Graph 8
Select your theme for the graph

Finally, you can use a different Shape. So if your data is better represented by a Shape other than people, you can choose the best fit. Now, click Shape and pick from the 16 options. See following image:

Graph 9
Select the Shape of your graph

Next, you can select and drag your People Graph wherever you want it on your spreadsheet. And if you edit the data on which the graph is based, Excel will update the graph automatically. Refer to below image:

Graph 10
Your final result

Other Options

On the top right of your People Graph, you will see an arrow (Windows) or an Info icon (Mac). When you click, you will see several actions .Choose Reload to refresh the graph, Delete to remove it, and Select to select the graph if you want to move it. You also have options to Get Support, Attach Debugger, and view the Security info. See below image:

Graph 11
Select Other Options

If you are looking for a simple way to visually display data, especially if it includes a number of people like customers, clients, or contacts, try out the People Graph in Microsoft Excel.

Quote For the Day

If you don’t like what you’re doing, then don’t do it

Ray Bradbury

That’s it. Please feel free to share this post! One way to share is via Twitter.

Just click the Tweet icon below. This will launch Twitter where you click its icon to post the Tweet.

Check out TechSavvy.Life for blog posts on smartphones, PCs, and Macs! You may email us at contact@techsavvy.life for comments or questions.

I Would Like to Hear From You

Please feel free to leave a comment. I would love hearing from you. Do you have a computer or smart device tech question? I will do my best to answer your inquiry. Just send an email to contact@techsavvy.life. Please mention the device, app and version that you are using. To help us out, you can send screenshots of your data related to your question.

The author’s Vietnam eBook on the Battle for Tra Bong Vietnam: Events and Aftermath

Author: Raymond

I am Raymond Oglesby, an Information Technology (IT) specialist with 30 years in the field. I have taught Microsoft Applications and troubleshot computers in 15 countries and many States. My career was focused on mainframes and desktops from application development to implementation. I have written hundreds of programs for various architectures. I decided to start a blog to share my knowledge and experiences with you. I plan on updating this blog at least twice a week about smart phone apps to Windows. Please feel free to leave a Comment or Tweet. I would love to hear from you. Do you have a computer tech question? I will do my best to answer your inquiry. Please mention the app and version that you are using. To help me out, you can send screenshots of your data related to your question.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.