How to Insert a People Graph in Excel

insert a people graph in excel

It was first introduced with Microsoft Excel 2013 to help people to create infographics.

In a people graph, instead of column, bar or a line, we have icons to present the data. And, it looks nice and professional.

So today, in this post, I’d like share with simple steps to insert a people graph in Excel and the option which we can use with it.

So let’s get started.

Quick Navigation

7 Steps to Insert a People Graph in Excel

Creating a people graph in Excel is simple and easy, we just need few clicks. Here is the data table which I’m using here, you can download it from here to follow along.

data to insert a people graph in excel
  • First of all, go to Insert Tab -> Add-Ins -> click on the small green button.
go to insert tab to insert a people graph in excel
  • It will insert a people graph with dummy data. Now, your next step is to connect data with the chart.
insert a people graph in excel
  • It will insert a people graph with dummy data. Now, your next step is to connect data with the chart.
two icons to insert a people graph in excel
  • Click on data icon and then click on select your data button.
select your data to insert a people graph in excel
  • Now, select the data table and click on create button.
click on create to insert a people graph in excel
  • The last thing is to all a title for your chart.
  • Again click on the data icon and change the default title to the desired title.
enter title to insert a people graph in excel

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 some customization options which can do after that.

1. Chart Type

There are 3 pre-defined charts types which we can use. Click on the setting button and select a 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 which we can use. Click on the setting button and select a type 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 12 different shapes from which we can select. Click on the setting button and select a 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, sent it in an email, upload to the web, etc.

5. More

  • When you update any value in the source data, make sure to click on the graph once to update it.
  • You can also paste it as an image in the worksheet by copy paste.

Conclusion

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

You can also use it in your dashboards and templates to give them an awesome look and for an effective way make others understand 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, please don’t forget to share this charting tip with your friends.

Content Protection by DMCA.com
2018-11-16T06:13:29+00:00

11 Comments

  1. Patty Ball 20 Nov, 17 at 7:40 pm - Reply

    can’t seem to find the link to download the data table

  2. duncanwil 15 Oct, 17 at 11:20 pm - Reply

    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.

    • Puneet Gogia 7 Nov, 17 at 10:59 am - Reply

      Thanks for correcting me.

  3. Imran 15 Oct, 17 at 7:45 am - Reply

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

    • Puneet Gogia 15 Oct, 17 at 7:47 am - Reply

      There’s always something new to learn, Imran.

  4. Vasu 11 Jul, 17 at 6:20 am - Reply

    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.

Leave A Comment