How to create a fun people chart in Excel

Is your chart annoying? Try Excel People Charts. How Susan Harkins shows you.

A yellow chart with the icons of the people attached to the numbers.

A man’s chart is an infographic, which leads me to the second definition. An infographic tells a story, apparently. Its purpose is to inform and educate, but in the business world, it is often used to create brand awareness. Even though you’re like me, humming drives you a little bad. So, an infographic hall in the world of Susan is a chart filled with related images. A person’s chart uses people’s icon-type images; So people chart. These are much more fun than traditional column or line charts, and viewers quickly grasp the information or story at a glance. In this article, I will show you how to create a Microsoft Excel guy chart.

See: Windows 11: Installation, Security and Tips (Free PDF) (TechRepublic)

I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use the .xlsx format version before 2013 and Excel for the web. I recommend that you stop upgrading to Windows 11 until all issues are resolved. For your convenience, you can download the Exhibit .xlsx file. Menu version, .xls, does not support human charts.

PeopleGraph is an Excel add-in

Excel supports human charts, but not directly. This is an add-in that you can retrieve from the Microsoft Store whenever you need. Before you begin, I suggest you reduce the zoom. The chart is big and it will be difficult for you to work with the chart if you do not zoom in less. Now, to make an insert now, do the following:

  1. Click the Insert tab.
  2. Click the add-in dropdown and select People Graph (Figure A) Terms graphs and charts are not really interchangeable, but use product name graphs. I will use charts, which are graphical representations of data. All graph charts; Not all charts are graphs. The main difference here is that a graph represents the relationship between the data. Our people can be charts, so I’m going with charts.

Figure A

Excel requires your People Graph add-in.
Excel requires your People Graph add-in.

To create an Excel man chart, you need some data. Figure B Shows a simple data set with dummy charts. Believe it or not, click on this add-in button to fill in the blank chart frame with dummy data.

Figure B

The Excel add-in inserts a chart with dummy data.
The Excel add-in inserts a chart with dummy data.

How to connect Excel data to chart

At this point, you are ready to link the chart to the actual data Click on the dummy chart and then click on the data icon shown Figure C.

Figure C

Click the Data tab to connect the data to the chart.
Click the Data tab to connect the data to the chart.

The gear icon on the right will access the settings. Click the Select Your Data option and select Data, as shown in the Entertainment Survey Table Figure B, And click Create. I don’t know of any way to attach the dummy chart to the data in another sheet. It looks like the dummy chart must be on the same sheet as the data set

In a matter of seconds, you’ve created a chart of people showing up Figure d. Fortunately, you can customize the chart a bit if you don’t care for the original design.

Figure d

The chart is based on the survey data of the people.
The chart is based on the survey data of the people.

How to customize Excel’s people chart

Basic settings are enough, but you may want to customize the chart a bit. The type of chart to consider first. There are three, and to access them, click the Settings icon (the gear icon shown in Figure d) And select the type. The three defined chart types are shown Figure e.

Figure e

You can quickly change the chart type by clicking on one of the three defined types.
You can quickly change the chart type by clicking on one of the three defined types.

After selecting the type, select the theme; There are seven. I like the second chart type short conversation blob, but I don’t care for the orange background, so I chose the last theme, the red man on the white / gray background, as shown Figure F.

Figure F

You change the theme in Excel.
You change the theme in Excel.

The last, or third, setting allows us to change human shape. There are 16! I chose the third, which is “on the way” to look like a person to better define the subject of entertainment. Close the settings pane to see the finished chart sown Figure G..

Figure G.

You can change human icons in Excel.
You can change human icons in Excel.

As you can see

If you use a table object to store source data, people’s charts will be updated automatically when you update source data. People charts can be an interesting part of a dashboard. It’s quick and easy to create and really changes the mood – it’s much more interesting than a traditional column or line chart and the story is easier to understand, just a glimpse.

Leave a Reply

Your email address will not be published.