Excel Dynamic Filled Map Chart with Power Query

Excel Dynamic Filled Map Chart with Power Query

 

 

In this video I'll show you how you can use Excel Power Query to import data from a CSV file to Excel. We'll use Power Query's data transformation features to extract the required information from a column. Then we'll use the Group By feature to summarize the data by state.   

 

As a last step I'll show you how easy it is to create a Filled Map Chart based on this data set (available in Excel 2019 and Microsoft 365) in Excel.

 

Related Topics:

• How to Remove or Replace Errors in Your Pivot Tables 
• MTD Pivot Table Calculation for Christopher 
• Pivot Table Calculation Type Default to Sum Instead of Count 
• 3 Ways to Display (Multiple Items) in a Pivot Table Filter