In this Excel video tutorial, we are going to learn how to make a Heat Map Chart in Excel.

A practical and well-known example of using the heat map chart is when we see, in a football game, the map with the colors Green, Yellow and Red, showing the parts of the field where the player traveled the most during the game, or even, the parts of the pitch where the ball traveled the most during the match. This is a classic example of using the heat map chart in Excel.

Excel does not have a heat map chart by default, but we can build a heat graph in Excel through conditional formatting and the sumIfs function in Excel.

Conditional Formatting in Excel helps us to automatically paint values in cells. We can use it to paint an entire line in the Excel worksheet or even just a specific cell of the color that we choose in order to met a criteria or a condition.

The first step is to have a database or a table with information that we will use in our heat map so that we can carry out analyses.

And, from this information, we can use the sumifs function in Excel and also the conditional formatting functionality to automatically paint the largest values in green, the smallest values in red and the intermediate values in yellow.

I'm going to use three main columns in the Excel spreadsheet. The first column is where I have the first category that I am going to analyze, the second column is where I have the second category that I am going to analyze, and the last column is the total value, or even, the result of these two previous columns.

The sums function in Excel can help us to automate the joining of these columns, to automate the sum of these two columns. So, the sumif function is an excellent function in Excel to save time in or daily routine in the job or with another tasks.

In addition to using conditional formatting with the conventional colors, green, yellow and red, you can also customize the colors you use by choosing the colors you want according to your personal taste, or you can use other formatting models and colors that Excel already provides.

#JopaExcel #Dashboard #Excel