MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Create Filled Map Charts in Office 365


March 25, 2019 - by Bill Jelen

Excel Create Filled Map Charts in Office 365. Photo Credit: Arthur Edelman at Unsplash.com

Early in 2017, Map Charts appeared on the Insert tab in Office 365. A Map chart shades closed regions on a map such as countries, states, counties, even zip code boundaries.

continue reading »

More Reading


Wondering if you should upgrade to Office 2019 or Office 365?

Editorial: Microsoft Should Stop Selling Office 2019 to the General Public »

March 24, 2019 - by Bill Jelen


Wondering if you should upgrade to Office 2019 or Office 365? If you have access to the Internet, there is only one viable choice, and it is Office 365.

Create Funnel Charts in Office 365. Photo Credit: YIFEI CHEN at Unsplash.com

Excel 2019: Create Funnel Charts in Office 365 »

March 22, 2019 - by Bill Jelen


In 2016, Office 365 introduced Funnel charts, as well as Treemap, Sunburst, Box & Whisker, Pareto, and Histogram charts. A Funnel chart is great for showing a sales funnel.

read more articles »


IMA Data Analytics Leveraging Excel

Featured Products


Excel Subtotals Straight to the Point

Excel Subtotals Straight to the Point »


I used to use the Subtotals feature daily after downloading mainframe data. This book covers every tip and trick for using Subtotals.

MrExcel LX – The Holy Grail of Excel Tips

MrExcel LX – The Holy Grail of Excel Tips »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

100 Excel Simulations

100 Excel Simulations »


Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

Cleaning Excel Data With Power Query Straight To The Point

Cleaning Excel Data With Power Query Straight To The Point »


This book provides a quick Straight-to-the-Point introduction to Power Query. There’s a lot here, and there’s also a lot that’s not here. Reading this book will be like sitting down at a café and striking up a conversation with the person at the next table, where you learn enough random stuff about that person to decide if you want to know more and keep in touch.

Your Excel Survival Kit

Your Excel Survival Kit »


This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

MrExcel LIVe

MrExcel LIVe »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

see more products »