Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below.
We recently updated our Terms and Conditions for TechRepublic Premium. By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.
You will also receive a complimentary subscription to TechRepublic’s News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.
Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
How to create a fun people chart in Excel
Your email has been sent
Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how.
A yellow chart with icons of people attached to numbers.
A people chart is an infographic, which leads me to a second definition. An infographic tells a story, visually. Its purpose is to inform and educate, but in the business world, it’s often used to build brand awareness. If you’re like me though, buzz words drive you a bit nutty. So, in Susan’s world an infographic is a chart filled with related images. A people chart uses icon-type images of people; hence people chart. They’re much more fun than the more traditional column or line charts, and viewers grasp the information or story with a quick glance. In this article, I’ll show you how to create a Microsoft Excel people chart.
SEE: Windows 11: Tips on installation, security and more (free PDF) (TechRepublic)
I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use an earlier .xlsx format versions back to 2013 and Excel for the web. I recommend that you hold off on upgrading to Windows 11 until all the kinks are worked out. For your convenience, you can download the demonstration .xlsx file. The menu version, .xls, doesn’t support people charts.
Excel supports the people chart, but not directly. It’s an add-in that you’ll retrieve from the Microsoft store every time you need one. Before you start, I recommend that you reduce the zoom. The chart is large and unless you reduce the zoom, you will find it hard to work with the chart. Now, to insert one now, do the following:
Figure A
To populate an Excel people chart, you need some data. Figure B shows a simple data set along with the dummy chart. Click the Trust This Add-in button to get started, which will populate the empty chart frame with dummy data.
Figure B
At this point, you’re ready to connect the chart to real data. Click the dummy chart and then click the Data icon shown in Figure C.
Figure C
The gear icon to the right will access settings. Click the Select Your Data option and select the data, the entertainment survey table shown in Figure B, and click Create. I don’t know of any way to connect the dummy chart to data on another sheet. It looks like the dummy chart must be in the same sheet as the data set.
Within seconds, you’ve created the people chart shown in Figure D. Fortunately, you can customize the chart a bit if you don’t care for the original design.
Figure D
The original settings are adequate, but you might want to customize the chart a bit. First to consider is the chart type. There are three, and to access them, click the Settings icon (the gear icon shown in Figure D) and choose Type. The three defined chart types are shown in Figure E.
Figure E
After choosing the type, choose Theme; there are seven. I like the little conversation blubs of the second chart type, but I don’t care for the orange background, so I chose the last theme, the red people on a white/gray background, as shown in Figure F.
Figure F
The last, or third setting, lets us change the shape of the people. There are 16! I selected the third, which looks like a person “on the go” to better define the entertainment topic. Close the settings pane to see the finished chart sown in Figure G.
Figure G
If you use a table object to store the source data, the people chart will update automatically when you update the source data. The people chart 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 that a traditional column or line chart, and the story is easy to discern, which just a quick glance.
Be your company’s Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets.
How to create a fun people chart in Excel
Your email has been sent
Your message has been sent
TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.
Encryption software protects confidential and private data in transit and at rest by making it accessible only to authorized individuals. Learn about the best encryption software and techniques.
Users can access several key Microsoft applications with keyboard shortcuts and a standard keyboard, but increased efficiency is limited without some special tricks.
Jack Wallen takes on the age-old question of what Linux needs to succeed on the desktop. This time around, his answers have nothing to do with software.
Want to enhance and highlight your IT skills? A tech-focused certification might do the trick. These top IT certification prep tools can help.
Ethisphere has released its annual edition of the most ethical companies from a variety of industries.
Video game writing jobs are in demand. Recruiting a video game/quest writer with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit from TechRepublic Premium includes a job description, sample interview questions and a basic want ad that you can customize for your business to find, interview, …
Recruiting an IoT architect with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit from TechRepublic Premium includes a job description, sample interview questions and a basic want ad that you can customize for your business to find, interview, recruit and hire the best candidates for an …
This hiring kit from TechRepublic Premium contains a job description, sample interview questions and a basic want ad to help you find, interview, recruit and hire the best candidates for an open FinTech Engineer position. From the hiring kit’s introduction: Over the past decade or so, particularly after the general proliferation of smartphones at the …
This hiring kit from TechRepublic Premium contains a job description, sample interview questions and a basic want ad to help you find, interview, recruit and hire the best candidates for an open Virtual Reality Designer position. From the hiring kit’s introduction: While the concept of virtual and augmented reality applications has been around for decades, …

source