{"id":8512,"date":"2018-12-27T11:10:34","date_gmt":"2018-12-27T11:10:34","guid":{"rendered":"http:\/\/www.nurturetechacademy.in\/?p=8512"},"modified":"2018-12-27T11:10:34","modified_gmt":"2018-12-27T11:10:34","slug":"heat-map-chart-radio-button-excel","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/heat-map-chart-radio-button-excel\/","title":{"rendered":"Heat Map Chart through Radio Button in Excel"},"content":{"rendered":"<p><strong><u>Heat Map Chart through Radio Button in Excel-<\/u><\/strong><\/p>\n<p>If we wish to highlight Top and bottom values in excel along with colour, rather than finding it manually, simply we will use conditional formatting.<\/p>\n<p>Today we will discuss a different way to highlight Top &amp; Bottom values with radio button along with colours. Are you Excited! Let\u2019s get started.<\/p>\n<p>Before going to start the process, firstly we have to understand-<\/p>\n<p>What is a radio button?<\/p>\n<p>A Radio button allows the user to select an option which updates a report. It\u2019s also called option button.<\/p>\n<p>How to use a radio button?<\/p>\n<p>We can get this button under the developer tab. To Add developer tab in excel, follow the steps-<\/p>\n<p>For ms-office 2007-<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8513\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/1.jpg\" alt=\"\" width=\"541\" height=\"53\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/1.jpg 541w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/1-300x29.jpg 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/p>\n<p>Office button-&gt; Excel Option-&gt; In the option Popular-&gt; check mark \u201cShow Developer tab in Ribbon\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8515\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/2.jpg\" alt=\"\" width=\"515\" height=\"442\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/2.jpg 515w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/2-300x257.jpg 300w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8516\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/3.jpg\" alt=\"\" width=\"531\" height=\"297\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/3.jpg 531w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/3-300x168.jpg 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<p>For Ms-Office 2010 or Upper version-<\/p>\n<p>File-&gt;Option-&gt;customize ribbon -&gt; check mark Developer -&gt; Ok<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8517\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/4.jpg\" alt=\"\" width=\"571\" height=\"356\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/4.jpg 571w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/4-300x187.jpg 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/p>\n<p>Go to Ribbon Tab-&gt; Developer tab -&gt; Insert-&gt; Form control \u2013&gt; Select Radio button<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8518\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/5.jpg\" alt=\"\" width=\"576\" height=\"237\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/5.jpg 576w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/5-300x123.jpg 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p>Now everything is in order, let\u2019s start the process step by Step-<\/p>\n<p>Step1- Insert two radio buttons-<\/p>\n<ul>\n<li>Developer Tab<\/li>\n<li>Insert<\/li>\n<li>Radio button or Option button<\/li>\n<li>Give them a name (Top_10 and Bottom_10)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8519\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/6.jpg\" alt=\"\" width=\"491\" height=\"260\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/6.jpg 491w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/6-300x159.jpg 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/p>\n<p>Radio Button Properties-<\/p>\n<ul>\n<li>Right click on a button<\/li>\n<li>Format control<\/li>\n<li>Mark on checked<\/li>\n<li>Select cell address (H2) to create a link with radio button<\/li>\n<li>Ok<\/li>\n<\/ul>\n<p><em>Note: Follow the same process for the next button<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8520\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/7.jpg\" alt=\"\" width=\"446\" height=\"475\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/7.jpg 446w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/7-282x300.jpg 282w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p><em>Note: As explained above, we make a link with cell address (H2), when we click on heading Top_10, we can see that Cell address (H2) showing Numerical 1 and when we click on next heading bottom_10, it\u2019s showing 2. Now H2 is behaving like a base cell for both buttons.<\/em><\/p>\n<p>Step2-<\/p>\n<ul>\n<li>Select the data set without headings<\/li>\n<li>Conditional formatting<\/li>\n<li>New rule<\/li>\n<li>Click on \u201cuse a formula to determine which cell to format\u201d<\/li>\n<li>Type this formula<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8522\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/8-1.jpg\" alt=\"\" width=\"311\" height=\"224\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/8-1.jpg 311w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/8-1-300x216.jpg 300w\" sizes=\"auto, (max-width: 311px) 100vw, 311px\" \/><\/p>\n<ul>\n<li><span style=\"color: #008000;\"><u>=IF($H$2=1,IF(B2&gt;LARGE($B$2:$E$13,10),TRUE,FALSE))<\/u><\/span><\/li>\n<li>Format-&gt; Fill-&gt; Choose colour<\/li>\n<li>Ok<\/li>\n<\/ul>\n<p>This formula visualizes that Top_10, for bottom_10 follow the same process as explain above and apply this formula<\/p>\n<p><span style=\"color: #008000;\">&#8211;<u>=IF($H$2=2, IF(B2&lt;=SMALL($B$2:$E$13,10),TRUE,FALSE))<\/u><\/span><\/p>\n<p>Click and choose any button and see the effect.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8523\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/9.jpg\" alt=\"\" width=\"562\" height=\"273\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/9.jpg 562w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/12\/9-300x146.jpg 300w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/p>\n<p>Follow the process and we can easily apply this effect on any Dashboard or report.<\/p>\n<p>Hope you enjoy this blog post, we would love to hear your suggestion, ideas and if any query feels free to write in the comment box.<\/p>\n<p>Stay connected and Happy Learning \ud83d\ude0a<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8512\" class=\"pvc_stats all  \" data-element-id=\"8512\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Heat Map Chart through Radio Button in Excel-<br \/>\nIf we wish to highlight Top and bottom values in excel along with colour, rather than finding it manually, simply we will use conditional formatting.<br \/>\nToday we will discuss a different way <\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8512\" class=\"pvc_stats all  \" data-element-id=\"8512\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":8526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[359,361,265,263,243,264,363,362,364,257,260,259,249,256,248,358,360,244,250,252,245,253,254,246,366,251,267,255,365,262,258,247,261],"class_list":["post-8512","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-chart","tag-chart-in-excel","tag-corporate-training-companies","tag-corporate-training-courses","tag-corporate-training-in-delhi","tag-corporate-training-programs","tag-excel-2010","tag-excel-2013","tag-excel-2016","tag-excel-course-online","tag-excel-courses-online","tag-excel-online-course","tag-excel-online-training","tag-excel-training-in-delhi","tag-excel-training-online","tag-heat-map","tag-heat-map-in-excel","tag-learn-microsoft-excel","tag-learn-ms-excel-online","tag-learning-excel-online","tag-learning-microsoft-excel","tag-microsoft-excel-course","tag-microsoft-excel-online-training","tag-microsoft-excel-training","tag-ms-excel","tag-ms-excel-learning","tag-ms-excel-online-training","tag-ms-excel-training-in-delhi","tag-office-365","tag-online-corporate-training","tag-online-excel-course","tag-online-excel-training","tag-online-excel-training-courses"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=8512"}],"version-history":[{"count":2,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8512\/revisions"}],"predecessor-version":[{"id":8527,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8512\/revisions\/8527"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/8526"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=8512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=8512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=8512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}