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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

14,277 views November 14, 2019 16:46

Watch on YouTube
ChannelKarina Adcock

Description from the creator

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: 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 youtu.be/ErEeyQmvlRI
- How to conditionally format a bubble chart in excel youtu.be/jdpGIcZGofA
- How to delete cells diagonally in excel youtu.be/USIQuYDmc20

About this tutorial

Karina Adcock published this 16:46 video tutorial on November 14, 2019. It has been watched 14,277 times on YouTube.

Duration
16:46
Published
November 14, 2019
Views
14,277
Likes
170

Tags

Share

This tutorial in other languages