The People Graph and Bing Maps are brilliant ways to create professional looking graphics in Excel in just a few clicks.
People Graph
Do not get too hung up on the word People in People Graph as other icons can be used and it can represent things than just people.
To get started you’ll need Excel open and have some date to reference:
Then click: The Insert tab > Add-ins > People Graph:
You’ll start off with this as your graphic:
Select your data and customise the settings until your graphic is just how you want it:
This is what we went for after tweaking a few settings:
Watch the video below and click here to learn more: People Graph (microsoft.com)
Bing Maps Infographic
Do you have data that you would like plotted on a map automatically for you? You can use multiple columns of data and Excel will take all of the formatting headaches away for you. It can be one plotted by postcodes, zip codes, countries and towns…the list is endless.
To get started you’ll need Excel open and have some date to reference:
Then click: The Insert tab > Add-ins > Bing Maps:
You’ll start off with this:
Select your data and customise the settings until your map is just how you want it:
Watch the video below and click here to learn more: Bing Maps (microsoft.com)
