Close

All MCPL Branches will be closed from 5:00 p.m. Nov. 25 through Nov. 29 for the Thanksgiving holiday as part of its COVID-19 response. Learn More. Our Virtual Branch is available 24/7.

Returns: Book Drops Only. Holds Pick-Up: Curbside or Drive-Up Service. In-Branch: No in-branch services. Virtual Branch is available 24/7.

The Grain Valley, Oak Grove, and Blue Springs North Branches are currently closed until further notice due to potential COVID-19 exposure. For a complete list of branches that are currently closed, visit the MCPL COVID-19 Information and Updates page.

Back to top

Spice Up Your Data with Excel Map Charts!

Published on Wed, 05/06/2020 - 10:59am
Spice Up Your Data with Excel Map Charts!

Excel spreadsheets can be very helpful in organizing and summarizing information, but the numbers may be even easier to visualize if that data is converted to a chart. If there is geographic information included in your Excel spreadsheet (country, state, county, or zip code), as well as numeric data, you may decide to create a map chart. If you’ve watched TV broadcasts about COVID-19, you’ve probably seen this type of map, but you may not have realized how easy it is to create them!

For our example, we’ll use a spreadsheet of the Midwestern states that lists their size by square miles.

Thumbnail

1.  First, we’ll select the column headings along with the states and their information. In this case, we’ll select A2:B14.

Thumbnail

2.  From the Insert tab of the ribbon, click the Maps button in the Charts group.

Thumbnail

3.  The Maps button has one more step: select Filled Maps.

Thumbnail

4.  To change the focus of the map, add state names, or change the default color scheme, right-click on the map. Select Format Data Series, which opens the Format Data Series pane on the right.

Thumbnail

5.  In the Format Data Series pane, change the map focus by selecting the Map area dropdown option that best fits your needs.

Thumbnail

6.  Add the names of the states by selecting the Map labels dropdown. You may decide that Show all is the better choice.

Thumbnail

7.  Change the color scheme to a 2-color or 3-color gradient by expanding the Series Color option and selecting the color combinations of your choice.

Thumbnail

If you’d like to watch a short video on how to create Excel map charts, tune into the MCPL360 Facebook page on Wednesday, May 6, at 1:00 p.m. as our staff provides a tutorial!

To learn even more about Excel Charts, use these online resources, which you can access with your Library card:

Terri M.
Consumer Technology Specialist

 

Comments

Which version of Microsoft Excel is used here? I tried following the steps in Excel 2016, but that didn't work.

From Matthew W (not verified)
Sat, 05/16/2020 - 01:28pm

I used Office 365, but Excel 2016 is roughly equivalent in what it offers.
Here's a note from the Microsoft support page ( https://support.microsoft.com/en-us/office/format-a-map-chart-2c744937-… ): Map charts are only available in Excel 2016 if you have a Microsoft 365 subscription. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office.
One other thought. While I've not needed to do this, you might select your cells with geographic data and define the cells as geography data types (Data tab > Data Types > Geography)

From Terri M. (not verified)
Mon, 05/18/2020 - 08:37am

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.

Resources You May Also Like

Events You May Also Like

Word Basics: Copy/Cut/Paste (MCPL360)

Tue, Dec 29 2020
2:00pm - 2:30pm
Virtual Event
Learn how to make a copy of text and place that copy where you want it or move text from one place in your document to another. Use paste options effectively to easily create a great document.

Blogs You May Also Like

An Alternate to Microsoft Word

An Alternate to Microsoft Word

One of the most popular software programs today is Microsoft Word® and its accompanying programs, Excel
Read More
Windows 7

Warning: Windows 7 Support Is Ending!

As of January 14, Microsoft will no longer support the Windows 7 Operating System.
Read More
Online Educator Resources

Online Educator Resources

Are you looking for student materials to help with the transition to flexible online learning?
Read More
gardening

Whip Those Pre-Winter Chores with MCPL!

As summer winds down, I’m sure like me, your thoughts turn to back-to-school events, pumpkin spice everything,
Read More

Was this page helpful? Yes No