Create a map chart in Excel from Web data

by | Feb 19, 2018

You can use Microsoft’s Map Chart to compare values and show categories across geographical regions. The map chart works with geographical regions. This means your data should have

  1. Countries
  2. Regions
  3. States
  4. Counties
  5. Postal codes

Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

To create a map chart

  1. Click a cell in your data range or table.
  2. Select the Insert tab > Charts > Maps.
  3. Click OK.

Video on creating a map chart

Upcoming events with Chris Menard

Chris will be presenting at the Administrative Professional Day Conference at the University of Georgia in Athens, GA on April 20, 2018. Menard’s presentation will be Excel & Word Tips to Make Your Life Easier! 

UGA website to register for the conference:

https://www.georgiacenter.uga.edu/courses/business-and-leadership/admin-prof-day

Who should attend?

  • Business/Office Managers
  • Executive Assistants
  • Administrative Assistants, Associates and Specialists
  • HR Coordinators, Specialists, and Associates
  • Meeting Planners
  • Customer Service Representatives
  • Office Assistants and Clerks
  • Anyone You Wish to Honor!

 

chris menard on Linkedinchris menard on Youtube
chris menard
Microsoft Office Master Instructor
I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I'm not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I've created come from questions asked during MS Office training.

Pin It on Pinterest