[www.keralites.net] Excel Tip: Creating Heat Maps for Management Reports

 

Creating Heat Maps

A heat map is nothing but a visual representation of data where color changes based on the value. For example, you can create a heat map where a cell with highest value is colored green and there is a shift towards red color as the value decreases. 

Something as shown below 

To create this, go to Home –> Conditional Formatting –> Color Scales, and choose one of the color schemes

Note: Similarly, you can also insert data bars or Icon sets

source; ExcelTrump

---

www.keralites.net

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 28

Visit Your Group

KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___