How to make a correlation matrix in excel using a bubble chart

In this video I show you how to plot a correlation table as a correlation matrix where the size of the circle and the color of the circle represent how good the correlation is. In this video we use power query to unpivot the table and a bubble chart to plot the correlations.
--------------------------------------------------------------------------------
#exceltutorial #excelcharts #exceltipsandtricks

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 1902

These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make a map in excel using a bubble chart    • How to make a map in excel using a bu...  
- How to conditionally format a bubble chart in excel    • How to conditionally format a bubble ...  
- How to delete cells diagonally in excel    • How to delete cells diagonally in excel