MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Power Map From Two Data Sets

June 21, 2018 - by Bill Jelen

Power Map From Two Data Sets

A question from my Melbourne Florida Power Excel seminar: Is it possible to display two different data sets in Excel Power Map (Excel 2013) or Excel 3D Map (Excel 2016+)? I knew this was possible because I've seen it in a Microsoft demo. I just wasn't sure how Microsoft did it.

The trick is to add each data set to the workbook Data Model before creating the map.

First, select one cell in your first data set. Press Ctrl + T to Format as Table. Make sure that box for Use First Row as Headers is checked. Repeat for the second table.

Make both data sets in to a table
Make both data sets in to a table

Adding the data to the data model could be very simple if you have a tab in the Excel ribbon called Power Pivot. In May 2018, Microsoft announced that all versions of Office 365 would soon have this tab. If you own the perpetual version of Office 2013 or Office 2016, you might not have the tab. If you have the Power Pivot tab, follow these steps:

continue reading »

More Reading

Place People on Bell Curve

Place People on Bell Curve »

June 19, 2018 - by Bill Jelen

Jimmy in Huntsville wants to plot a bell curve showing the average scores of several people. When Jimmy asked the question during my Power Excel Seminar, I thought back to one of my more popular videos on YouTube.

Combine Based on Common Column

Combine Based on Common Column »

June 14, 2018 - by Bill Jelen

David from Florida asks today's question: "I have two workbooks. Both have the same data in column A, but the remaining columns are different. How can I merge those two workbooks?"

read more news »

Featured Products

Supercharge Power BI

Supercharge Power BI »

If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016 »

Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

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.

Supercharge Excel When You Learn to Write DAX For Power Pivot

Supercharge Excel When You Learn to Write DAX For Power Pivot »

Hands-on book to learn and master the DAX language!

Excel Video Medley

Excel Video Medley »

Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

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.

see more products »