Excel People Chart - AdvantEdge Training & Consulting

Excel People Chart

excel people chartMicrosoft opened their Office suite to 3rd party development in 2013. In the same way that the functionality of a smart phone can be extended with an app, Microsoft Office apps can be downloaded to add new features.

Microsoft itself created several apps, one of which is the Numbers About People App. It creates useful charts to visually represent data.

Get the data

excel people chartTo start with, I needed data. Rather than copying and pasting or manually entering data, I clicked on the From Web option under the Data tab. I searched for the Wikipedia page for countries ranked by size of population and clicked import.
I had to clean up the data a little. If this were a permanent project, I might want to use Power Query, so that future changes to the data can be reflected in the graphs without manual intervention. For the purposes of this exercise, I just deleted rows and reformatted the information manually.

Using the App

Once the data was ready, I clicked the Numbers About People icon in the Apps Group of the Insert tab. (Your screen may look different depending on which version you have, or how it was installed.)
I clicked the Calculator icon in the top right hand corner to select my data and clicked OK. The gear controls which icons and colors are used.
Find other apps to use on the Microsoft Office App Store with the Store icon in the Apps group of the Insert tab.

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top