www.makeuseof.com Open in urlscan Pro
52.223.42.198  Public Scan

Form analysis
1 forms found in the DOM

GET /search/?q=

<form method="get" class="search-form js-searchBox icon i-search" id="searchform2" action="/search/?q=">
  <input id="js-search-input" type="text" name="q" class="input-text search-input" autocomplete="off" placeholder="Search MUO" autofocus="">
</form>

Text Content

MAKEUSEOF

Newsletter
Trending Samsung Galaxy Unpacked Threads Apple Beta ChatGPT PS5 Scams Windows 11
Emojis Explained Free ChatGPT Ebook
 * * PC & Mobile
     * Windows
     * Mac
     * Linux
     * Android
     * iOS
   * Internet
     * Social Media
     * Security
     * Programming
   * Productivity
     * Work & Career
     * Creative
     * DIY
   * Lifestyle
     * Smart Home
     * Wellness
     * Gaming
     * Entertainment
   * Tech Explained
     * Artificial Intelligence
     * Crypto
     * Tech Jargon
     * Networking
     * Electric Vehicles
 * * More
     * Buyer's Guides
     * Product Reviews
     * Free Cheat Sheets
     * Deals
     * Podcasts

 * Join Our Team
 * Newsletter
 * Advertise with us

 * 
 * 
 * 
 * 
 * 
 * 
 * 

 * Write For Us
 * Home
 * Contact Us
 * Terms
 * Privacy
 * Copyright
 * About Us
 * Fact Checking Policy
 * Corrections Policy
 * Ethics Policy
 * Ownership Policy
 * Partnership Disclaimer
 * Official Giveaway Rules


Copyright © 2023 www.makeuseof.com


 * Home
 * Productivity


HOW TO CREATE A HEAT MAP IN EXCEL

By Razvan Mihaila
Published Sep 25, 2022


Heat maps are a great tool to analyze large amounts of data quickly and compare
different values. Here's how to create a heat map in Excel.


Readers like you help support MUO. When you make a purchase using links on our
site, we may earn an affiliate commission. Read More.

Heat maps are a great tool to analyze a lot of data at once, as it uses
different colors to represent data instead of having to compare every value. If
you need a heat map for your job but don’t know where to start, we’re here to
help.

Close
Powered By

00:00/10:23




10



Unihertz Luna Review: A Stranger Clone of an Already Strange Phone


Share

Next
Stay





In this article, we’ll show you how to create a heat map in Excel and how you
can customize it by adding more formatting rules or removing the numbers.




CREATE A HEAT MAP WITH CONDITIONAL FORMATTING IN EXCEL

You can create a heat map in Excel using the Conditional Formatting feature.
This method has the advantage that you can change the data, and the heat map
will update accordingly. Here’s how you can create a heat map once you’ve
gathered all your data:

 1. Select the data you want to include in the heat map.
 2. Open the Home tab.
 3. Go to Conditional Formatting > Color Scales.
 4. Choose one of the displayed options. You can test multiple options by
    hovering your mouse over them, as Excel will preview how the heat map will
    look.




HOW TO ADD MORE RULES TO THE HEAT MAP

If you want to create a professional-looking Excel spreadsheet, you can add more
rules to your heat map. Head to Conditional Formatting > Color Scales and select
More Rules. You can choose a new rule from the Select a Rule Type list.



For this example, we’ll pick the Format all cells based on their values option
and set Format Style to 3-Color Scale. Now, you can edit the Minimum, Midpoint,
and Maximum settings. You can even change the colors to make the map easier to
understand. Once you’re done setting the new rules, click OK.





ADD A HEAT MAP TO EXCEL PIVOT TABLE

If you wanted to analyze your data from different perspectives, there’s a chance
you’ve already created a pivot table in Excel. You can still add a heat map to
your table by going through the above steps, but if you edit the table, Excel
might not apply the conditional formatting rules to the new data, depending on
your settings.

However, you can easily fix it and have the pivot table update itself every time
you change the data.

 1. Select the cells containing relevant data.
 2. Go to Conditional Formatting > Color Scales and pick one of the available
    options.
 3. Again, open the Conditional Formatting menu and click Manage Rules. Excel
    will display the Conditional Formatting Rules Manager window.
 4. Click the Edit Rule button.
 5. Check the Selected cells option.
 6. Select the cells with relevant data and click OK.






HOW TO REMOVE NUMBERS FROM YOUR HEAT MAP IN EXCEL

If you want to visualize data without getting into details, you can remove the
numbers from your heat map. This is a great data visualization method that adds
value to your reports.

To remove each cell’s value without affecting the visual representation, open
the Home tab, select the cells and go to Format > Format Cells.



From the Category menu, select the Custom option. Then, type ;;; (three
semicolons) and click OK.




That’s it. You can now visualize the heat map without any numbers.




VISUALIZE DATA WITH HEAT MAPS IN EXCEL

Once you get the hang of it, creating a heat map for your tables shouldn’t take
too much. Even if you need to modify the data after creating the heat map, you
should have no problem keeping the heat map updated using the methods that we’ve
presented.

The truth is, that a visual representation, such as a heat map, is easier to
grasp than text and numbers. Even if you can’t use a heat map, Excel has plenty
of chart and graph types that you can use to showcase data.


Subscribe to our newsletter
Comments
Share Tweet Share Share Share
Copy
Email
Share

Share Tweet Share Share Share
Copy
Email
Link copied to clipboard

Related Topics
 * Productivity
 * Microsoft Excel
 * Spreadsheet
 * Microsoft Office Tips
 * Data Analysis
 * Visualizations

About The Author
Razvan Mihaila (326 Articles Published)


Razvan has always been passionate about technology, which led him to graduate
with a Bachelor's degree in Engineering. Having left the corporate world, he
joined the MUO team in 2021. Now, he focuses on troubleshooting guides and tips
that improve the experience readers have with their devices.


Close



POLL

WHEN YOU GET A NEW PRODUCT, DO YOU READ THE INSTRUCTION MANUAL?

I read everything in the instruction manual
22%, 179 votes

I skim the instruction manual
25%, 206 votes

No, but I read the quick-start/how-to-use section
13%, 110 votes

Who reads the instruction manual?
8%, 70 votes

It depends on the product
32%, 267 votes

Total Votes: 832
See More Vote View results Discuss this poll




 * THREADS


 * ARTIFICIAL INTELLIGENCE

HOW TO ENABLE THREADS' FOLLOWING TAB

14 minutes ago

HOW TO CHANGE YOUR PROFILE PICTURE ON THREADS

7 days ago

HOW TO BLOCK OR MUTE A USER ON THREADS

Jul 18, 2023
See More

THE 8 BEST AI APPS TO DOWNLOAD ON YOUR PHONE

5 days ago

5 EFFECTIVE AI WRITING ASSISTANT TOOLS TO USE ON YOUR MAC

1 day ago

CHATGPT IS NOW AVAILABLE ON ANDROID

1 day ago
See More


TRENDING NOW

THE 11 MOST ANNOYING BUGS FIXED IN LIBREOFFICE 7.5.5



10 PASSIVE-AGGRESSIVE PHRASES TO AVOID IN THE DIGITAL WORKPLACE



HOW TO USE THE QUICK ANALYSIS TOOL IN EXCEL




✕

user-signalWir schätzen Ihre Privatsphäre
Alles akzeptieren
Wir und unsere Partner informationen auf einem gerät speichern und/oder abrufen.
Für die Ihnen angezeigten Verarbeitungszwecke können Cookies, Geräte-Kennungen
oder andere Informationen auf Ihrem Gerät gespeichert oder abgerufen werden.
Anzeigen und Inhalte können basierend auf einem Profil personalisiert werden. Es
können Daten hinzugefügt werden, um Anzeigen und Inhalte besser zu
personalisieren. Die Leistung von Anzeigen und Inhalten kann gemessen werden.
Erkenntnisse über die Zielgruppen, die die Anzeigen und Inhalte gesehen haben,
können abgeleitet werden. Ihre Daten können verwendet werden, um bestehende
Systeme und Software zu verbessern und neue Produkte zu entwickeln.

Einige Partner bitten nicht um Ihre Zustimmung zur Verarbeitung Ihrer Daten und
verlassen sich stattdessen auf deren berechtigtes Interesse. Sehen Sie sich
unsere Liste der Partner an, um zu sehen, für welche Zwecke sie ein berechtigtes
Interesse haben und wie Sie dagegen Einwände erheben können.

Ihre Auswahl auf dieser Website wird für diese Website angewendet. Sie können
Ihre Einstellungen jederzeit ändern, indem Sie Ihre Einwilligung widerrufen,
indem Sie auf das Schlosssymbol in der unteren rechten oder linken Ecke klicken.

checklistZweckesettings-toggle-horizontalPartner
Powered By