---
title: "Tip of the Week: Using People Graph in Microsoft Excel - Get a Free Network Security Consultation in South Florida"
description: "Microsoft Excel features a variety of data visualization tools. Let’s go over how to use People Graph to display your data."
url: "https://www.l7solutions.com/blog/tip-of-the-week-using-people-graph-in-microsoft-excel"
date: "2026-06-19T22:23:36+00:00"
language: "en-GB"
---
## Get a Free Network Security Consultation in South Florida
Get a free network security consultation today from L7 Solutions. We are your partner for managed services & IT support in South Florida and beyond. Call today.
[ Categories ](https://www.l7solutions.com/blog/categories "Categories")
[ Tags ](https://www.l7solutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.l7solutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.l7solutions.com/javascript:void(0);)
# Tip of the Week: Using People Graph in Microsoft Excel
[LSeven Solutions Blog](https://www.l7solutions.com/blog/categories/blog) [Tip of the Week](https://www.l7solutions.com/blog/categories/tip-of-the-week)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
Monday, 24 July 2023
[ 0 Comments ](https://www.l7solutions.com/blog/tip-of-the-week-using-people-graph-in-microsoft-excel#comments)
[  ](//www.l7solutions.com/images/easyblog_shared/July_2023/07-24-23/551542200_peoplegraph_400.jpg "Tip of the Week: Using People Graph in Microsoft Excel")
Microsoft Excel is a great way for data to be visualized, particularly as it offers various features to highlight the context of the data you’re trying to communicate with. Today, we wanted to walk you through how you can use one such feature—People Graphs—to do so particularly impactfully.
## What are People Graphs?
People Graphs are a Microsoft Office Add-In that allows you to create a quick data visualization. While the default icon included in the People Graphs is, predictably, a person, the graphs can be customized to display different icons—from a star, a heart, a clock, a bag of money or various others.
Let’s go over how you can create these simple graphs to present simple data points to your advantage.
## Creating a People Graph
First, you need to have the data you want your People Graph to depict in your spreadsheet. Let’s assume that you wanted to share some statistics concerning the work/life balance habits of today’s workers. In one column, list out the stats you want to share, and in the next, list out the numerical values associated with these statistics.
Select this data range. Then, in the **Insert** toolbar, select **People Graph** under **Add-Ins**. A premade graph will appear on your sheet. Select the **Settings** option, which will appear in the top-right corner when you click on the graph.
From there, you can customize what your graph looks like, its color scheme, and the shape of the icon itself.
Once you’re pleased with the appearance of your graph, you can then select the grid button that appears next to the settings option. From there, you can customize the title and select the data that your graph pulls from.
Once you’ve selected the data, click **Create**, and your People Graph is complete.
Hopefully, you find plenty of use out of this capability!
[ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);)
Tags:
[Data](https://www.l7solutions.com/blog/tags/data) [Quick Tips](https://www.l7solutions.com/blog/tags/quick-tips) [Microsoft Office](https://www.l7solutions.com/blog/tags/microsoft-office) [Tip of the Week](https://www.l7solutions.com/blog/tags/tip-of-the-week)
[ Why You Might Consider Taking Your Security to the... ](https://www.l7solutions.com/blog/why-you-might-consider-taking-your-security-to-the-edge)
[ Looking at the Benefits of Cloud vs. Onsite Storag... ](https://www.l7solutions.com/blog/looking-at-the-benefits-of-cloud-vs-onsite-storage)
About the author
[  ](https://www.l7solutions.com/blog/blogger/l7-admin)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
[ ](https://www.l7solutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/blog/blogger/l7-admin)
Welcome to LSeven's Blog! Here we will share useful tips and tricks for Computers and Information on Our IT Services!
Author's recent posts
[More posts from author](https://www.l7solutions.com/blog/blogger/l7-admin)
[ Tuesday, 30 June 2026 Stop Managing Metal, Start Managing People: A Guide to Hybrid IT ](https://www.l7solutions.com/blog/stop-managing-metal-start-managing-people-a-guide-to-hybrid-it)
[ Saturday, 27 June 2026 Free AI is Not Free: Why Public Tools Are a Security Risk ](https://www.l7solutions.com/blog/free-ai-is-not-free-why-public-tools-are-a-security-risk)
[ Thursday, 25 June 2026 Phishing is Getting Sophisticated: The New Threats Businesses Face ](https://www.l7solutions.com/blog/phishing-is-getting-sophisticated-the-new-threats-businesses-face)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.l7solutions.com/component/users/login?return=aHR0cHM6Ly93d3cubDdzb2x1dGlvbnMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLXVzaW5nLXBlb3BsZS1ncmFwaC1pbi1taWNyb3NvZnQtZXhjZWw=&Itemid=101)
Friday, 19 June 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**
## Schema
```json
{
"@context": "https://schema.org",
"@type": "BreadcrumbList",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"name": "Home",
"item": "https://www.l7solutions.com"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.l7solutions.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "LSeven Solutions Admin",
"item": "https://www.l7solutions.com/blog/blogger/l7-admin"
},
{
"@type": "ListItem",
"position": 4,
"name": "Tip of the Week: Using People Graph in Microsoft Excel",
"item": "https://www.l7solutions.com/blog/tip-of-the-week-using-people-graph-in-microsoft-excel"
}
]
}
```