If you take advantage of Microsoft Excel charts to get useful visualizations of your data, see the People Chart option to create a simple description of the number of people or items you have recorded in your spreadsheet.
You can show things like the number of visitors to your web portal, your app downloads, registrations for your event, calls to your support center and much more.
Add the People Graph add-in to Excel
People Graph is an add-in developed by Microsoft and there is already a button for it in the Excel ribbon. But before I can use it, will have to confidence the plugin to install it.
Open the Insert tab in Excel and find the Add-Ins group. Click the People Chart button.
You will see a pop-up window with a link to “See details”. This leads you to the add-in on the Office Store website, where you can read an overview, reviews and other details. Click on “Trust this plugin” to start.
Once the add-in is installed in Excel, you can click the button on the Insert tab to use the function when you need it.
RELATED: How to install and use add-ins for Microsoft Office
Insert a people chart
Whenever you press the People Graph button on the ribbon, you will see a sample chart. Click on the data icon that looks like a small grid.
Optionally, you can enter your chart title before choosing your data, or you can come back to this place to add the title later.
Click on “Choose your data” and then drag through the cells that you want to use. Today, must use two columns of data, but it can have multiple rows.
After, click on “Create” on the People Chart screen.
Customize your people chart
After inserting your people chart in Microsoft Excel, can customize it. Click on the gear icon to open settings. Next, you can scroll through the three type settings, subject and form.
Today you can select from three types of charts. Each has a slightly different design and appearance. Click on “Guy” and then choose one on the right side.
Next, you can choose a theme that changes the background and colors of the chart. Click on “Are you bored to use” and choose one of the seven options.
In summary, you can use a different way. Then, if your data is best represented by a form other than people, you can select the one that best fits. Click on “Form” and choose from the 16 options.
You can choose and drag your People Chart where you want it on your spreadsheet. And if you edit the data the chart is based on, Excel will update the chart automatically.
To update, delete or choose the people chart
At the top right of your people graph, you will see an arrow (Windows) or an information icon (Mac). Clicking, you will see various actions.
Choose “Reload” to update the chart, “Remove” to remove it and “Choose” to choose the chart if you want to move it. You also have options to get support, attach a debugger and view security information.
If you are looking for a simple way to display data visually, especially if you include multiple people as customers, clients or contacts, try the people chart in Microsoft Excel. And for another kind of useful chart, take a look at how to create tally chart in excel.