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.

⯆ Full article and csv file can be accessed here: https://www.xelplus.com/excel-filled-map-chart-using-power-query/

#excel #developer