30 Advanced Excel Tips for 2026

Excel Champs / Excel Charts / People Graph
By Puneet Gogia (Microsoft MVP)

How to Insert a People Graph in Excel

Go to Insert → Add-ins and click the small green People Graph icon. Excel places a graph with sample data on the sheet. If the icon is missing or greyed out, add it from Insert → Get Add-ins by searching for People Graph.

Click the Data icon at the top of the graph, choose Select Your Data, select a two-column range with the labels in the first column and the numbers in the second, and click Create. Type your own title in the same Data pane.

Use the Settings icon to pick one of 3 types, 7 themes and 12 shapes. That is the full extent of the formatting: People Graph is an Office add-in, not a built-in chart, so you can’t change the label fonts or edit it with the usual chart tools.

The graph doesn’t refresh on its own. After you change the source values, click the graph once to update it. A macro can’t drive it either, because VBA has no access to Office add-ins, so values a macro writes appear only after someone clicks the graph.

For more control, build a pictograph instead: create a bar chart, copy a person icon (from Insert → Icons or any image), then select the bars and use Format Data Series → Fill → Picture or texture fill → Clipboard with Stack and Scale with set to the number each icon should stand for.

I have been always fascinated with info-graphics and story-based visuals. These kinds of things help me to tell a story with data. A pictograph is a great example of this. But apart from this, there is a chart in Excel which most of us are not aware of.

That’s called: People Graph

insert a people graph in excel

It was first introduced with Microsoft Excel 2013 (as an Office add-in that comes with Excel) to help people create infographics. In a people graph, instead of a column, bar, or line, we have icons to present the data. And, it looks nice and professional.

Today, in this post, I’d like to share simple steps to insert a people graph in Excel and the options which we can use with it. So let’s get started.

7 Steps to Insert a People Graph in Excel

Creating a people graph in Excel is simple and easy; we just need a few clicks. Here is the data table which I’m using here. A people graph needs exactly two columns: one for the labels and one for the values.

data to insert a people graph in excel
  1. First of all, go to Insert Tab ➜ Add-ins ➜ click on the small green People Graph button. The first time, Excel asks you to trust the add-in; click “Trust this add-in”.
    go to insert tab to insert a people graph in excel
  2. It will insert a people graph with dummy data.
    insert a people graph in excel
  3. Now, your next step is to connect data with the chart.
    two icons to insert a people graph in excel
  4. Click on the Data icon and then click on the Select Your Data button.
    select your data to insert a people graph in excel
  5. Now, select the data table and click on the Create button.
    click on create to insert a people graph in excel
  6. The last thing is to add a title for your chart.
  7. Again, click on the Data icon and change the default title to the desired title.

Congratulations! Your first info-graphic is ready to tell its story. It’s a proud moment.

ready to use people graph in excel

Customization and Other Options

As I said, it’s easy to insert a people graph. But there are some customization options that you can use after that.

1. Chart Type

There are 3 pre-defined chart types that we can use. Click on the Settings button (the gear icon) and select the type which you want.

change type in people graph in excel

2. Theme

We can also use different themes for our chart. There are 7 pre-defined themes that we can use. Click on the Settings button and select the theme which you want.

change theme in people graph in excel

3. Shape (Icon)

We can’t use a single shape for all types of data. So that’s why there are different shapes from which we can select (12 when the add-in came out, 16 in current versions). Click on the Settings button and select the shape which you want.

change icons in people graph in excel

4. Save as Image

There is an option to save it as an image. With this, we can use it further in PowerPoint, send it in an email, upload it to the web, etc.

5. More

  • When you update any value in the source data, the graph updates on its own; if it doesn’t, click on the graph once to update it.
  • You can also paste it as an image in the worksheet with copy and paste.

People Graph Limitations

  • Two columns only: the data must have one label column and one value column, so you can’t show two series in one graph.
  • Add-in based: it’s an Office add-in, so it may be missing if your organization blocks add-ins, and it needs an internet connection the first time you insert it.
  • Rounded icons: the icons are a visual guide, and the exact numbers show next to them, so don’t use it where you need precise comparison.
  • Not a normal chart: you can’t format it with the chart tools; you only get the type, theme and shape options.

If you need more control, a pictograph made with a normal bar chart and icons gives you the same look with all the chart options.

Conclusion

Infographics are superb at presenting data in a vivid way. And I believe that creating a people graph in Excel is really fun.

You can also use it in your dashboards and templates to give them an awesome look and to help others understand the data. I’m sure you found this graph useful and it will help you in your work.

Now tell me one thing.

Have you ever tried this before? And do you think we can use it in our dashboards?

Please share your views in the comment section; I would love to hear from you. And, don’t forget to share this charting tip with your friends.

Frequently Asked Questions

Why can’t I find People Graph on the Insert tab?

Look in the Add-ins group of the Insert tab. If the button isn’t there, go to Insert ➜ Get Add-ins (or My Add-ins), search for People Graph and add it. If add-ins are turned off by your organization, ask your admin.

Does a people graph work on Mac?

Yes. People Graph is an Office add-in, so it works in Excel for Microsoft 365 on Windows and Mac, and in Excel for the web.

Can I use my own icons in a people graph?

No. You can only pick from the built-in shapes. For your own icons, create a pictograph with a bar chart instead.

20 thoughts on “How to Insert a People Graph in Excel”

  1. The people graph is a great tool. Will you be able to use more than two columns to tell you story?

    Thanks

    Reply
  2. Hi Puneet,

    How do it format the labels on the People graph. When I choose a particular type the labels for the age group I want to make it ‘ bold’. How do I do that.

    Thanks for sharing.

    Reply
    • I’m afraid that there’s no option that can help you to customize this chart because it’s more of a add-in. But here’s the link to create a pictograph where you can add an icon in the chart to and make all the customization that you need.

      https://excelchamps.com/excel-charts/pictograph/

      take care

      Reply
  3. Hello Puneet
    Please do you have an idea about people graph.

    someone sent me this “I have a question regarding Microsoft People Graph and installing it for a small group of users. Looks like it trying to do centralized deployment of the app”

    Reply
  4. There is a limitation of using this people graph, it is not showing the data more than 15 rows and I am unable to see the full graph even 10 rows are, it is displaying only 4 rows.

    Reply
  5. How can you get the images to represent a smaller population? I am trying to represent pregnancies per 1000 and it wants to represent per 10 not per 1.

    Reply
  6. can’t seem to find the link to download the data table

    Reply
  7. In the first of the seven steps you say, “Here is the data table …”. that is NOT a data table. It is not even, formally, a table. It’s a list or a range. At best it’s a frequency distribution table.

    Reply
  8. Dear Puneet, Thanks for Sharing People Graph. I have never use this type of graph. Thanks

    Reply
  9. Hi Puneet,
    That’s great and useful for me the people graph. But for me the Green People graph was not highlighted.
    Please help me how to get it.

    Reply

Leave a Comment