Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Make Excel Heatmap?

Let's say I have a dataset, a table with day-names and day-hours and some values filling the table.

 

How would you automatically colour cells to look like a heat map, colours gradually going from Red to Green (for example) where Red is bad value and Green is good?

 

This question just to see if different people have different solutions, I know the answer ;)

user-image
Question ajoutée par Salam Waddah , Staff Software Engineer , Hello Chef
Date de publication: 2017/03/09
Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

you just name the process with it's real name.

It is heat map Excel

1. select you data

2. use conditional formatting 

3. Choose the colors you want (red and green in your case)

4. pay attention to the logic order of the colors you want.

 

done

makes sense? hope

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?