{"id":6083,"date":"2019-07-18T18:41:37","date_gmt":"2019-07-18T10:41:37","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=6083"},"modified":"2025-04-16T14:48:53","modified_gmt":"2025-04-16T06:48:53","slug":"pure-report-operated-heat-map-tutorial-without-one-line-of-code","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/pure-report-operated-heat-map-tutorial-without-one-line-of-code.html","title":{"rendered":"Pure report-operated heat map tutorial without one line of code!"},"content":{"rendered":"\n<p>How can I create a heat map without writing a single line of code? It sounds very difficult, but it&#8217;s not really the case. Just use our reporting tool, <em><a href=\"http:\/\/www.finereport.com\/en\/\">FineReport<\/a><\/em>, to easily create a cool heat map with an excel-like operation!<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071801L.gif\" alt=\"\" class=\"wp-image-6111\"\/><figcaption>Made by <a href=\"http:\/\/www.finereport.com\/en\/\"><em>FineReport<\/em><\/a><\/figcaption><\/figure><\/div>\n\n\n\n<div id=\"toc_container\" class=\"toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#1_Find_the_data_source_for_the_heat_map\">1. Find the data source for the heat map<\/a><\/li><li><a href=\"#2_Connect_data_set_for_the_heat_map\">2. Connect data set for the heat map<\/a><\/li><li><a href=\"#3_Template_data_set_for_the_heat_map\">3. Template data set for the heat map<\/a><\/li><li><a href=\"#4_Template_style_design_for_the_heat_map\">4. Template style design for the heat map<\/a><\/li><li><a href=\"#5_Effect_display_for_the_heat_map\">5. Effect display for the heat map<\/a><\/li><\/ul><\/div>\n<h2><span id=\"1_Find_the_data_source_for_the_heat_map\"><strong>1. Find the data source<\/strong> for the heat map<\/span><\/h2>\n\n\n\n<p>The first step in data analysis is to find the source of the data. So where can I find the data for the seismic heat map? The answer is USGS. We can obtain seismic data of various regions from it. In this article, we take the world&#8217;s seismic data from 1999 to 2019 and import it into Excel and edit it into a unified format as shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071802L.png\" alt=\"\" class=\"wp-image-6112\"\/><\/figure>\n\n\n\n<h2><span id=\"2_Connect_data_set_for_the_heat_map\"><strong>2. Connect data set<\/strong> for the heat map<\/span><\/h2>\n\n\n\n<p>The data source is found, now\ndownload our FineReport (<a href=\"http:\/\/bit.ly\/2Y5clsR\">Download<\/a>) first~<\/p>\n\n\n\n<p>After completing the download,\nopen the designer and how to connect to the dataset? Since FineReport can&#8217;t\ndirectly connect to Excel data source, we need to put the excel data under the\npath of installing FineReport. At this time, re-open the designer, you will\nfind your Excel data file, and then import it. Select file, set file type as\nexcel, then choose local file, select the excel file just imported, on the\nright side select &#8220;First row contains column headings&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071803L.png\" alt=\"\" class=\"wp-image-6100\"\/><\/figure>\n\n\n\n<h2><span id=\"3_Template_data_set_for_the_heat_map\"><strong>3. Template data set<\/strong> for the heat map<\/span><\/h2>\n\n\n\n<p>Take a cell chart as an example, merge a\ncell, click Insert -&gt; Cell Element -&gt; Insert Chart, select the heat map,\nas shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071804L.png\" alt=\"\" class=\"wp-image-6102\"\/><\/figure>\n\n\n\n<p>Select the chart, on the right side select the chart property table -&gt; type, and select the heat map by default, as shown in the following figure: here I select Template Parameter, then select the GIS layer as Satellite (many other options). You can set the center point of the map display. Here I choose (101,0) to display Southeast Asia as the center.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071805L.png\" alt=\"\" class=\"wp-image-6113\"\/><\/figure>\n\n\n\n<p>Then set the map data, as follows<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071806L.png\" alt=\"\" class=\"wp-image-6114\"\/><\/figure>\n\n\n\n<h2><span id=\"4_Template_style_design_for_the_heat_map\"><strong>4. Template style design<\/strong> for the heat map<\/span><\/h2>\n\n\n\n<p>Next, adjust the specific form.<\/p>\n\n\n\n<p>The legend is set to a gradient color by default. You can define the maximum and minimum according to your needs. Select Chart Property Table -&gt; Style -&gt; Series, you can see that the series properties are divided into two settings: Heat point and BG area. If the boundary\/point selected by the user does not contain the boundary information, the setting is invalid. The series interface of the thermal point is as follows: the larger the rendering radius, the larger the display range of the heat region; the greater the blur, the higher the blur of the heat boundary. Opacity minimum and maximum, corresponding to the opacity of the minimum and maximum values in the graph, set here as follows.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071807L.png\" alt=\"\" class=\"wp-image-6115\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071808L.png\" alt=\"\" class=\"wp-image-6116\"\/><\/figure>\n\n\n\n<h2><span id=\"5_Effect_display_for_the_heat_map\"><strong>5. Effect display<\/strong> for the heat map<\/span><\/h2>\n\n\n\n<p>Finally click on the preview and all done!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071809L.png\" alt=\"\" class=\"wp-image-6117\"\/><\/figure>\n\n\n\n<p>Wow, the effect is great! Here is a heat map of earthquake in Southeast Asia. The darker the color, the higher the probability of an earthquake! Come and see where the earthquake is happening!<\/p>\n\n\n\n<p>Seeing here, someone may be a bit curious about how the Earth image at the beginning of the article was made. very simple! Just select structure(new) when inserting the chart. The subsequent settings can be experienced by yourself, very similar~<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019071810L.gif\" alt=\"\" class=\"wp-image-6118\"\/><\/figure><\/div>\n\n\n\n<p><em>Follow<a>&nbsp;<\/a><a href=\"https:\/\/www.facebook.com\/finereport\/\">FineReport Reporting Software<\/a>&nbsp;on Facebook to learn more about data visualization!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to make a cool heat map without writing code, this article can help you!<\/p>\n","protected":false},"author":1,"featured_media":6084,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[118],"yst_prominent_words":[1215,185,312,586,472,3979,1103,1030,845,1221,1199,1196,1149,1155,1198,1197,1194],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/6083"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=6083"}],"version-history":[{"count":6,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/6083\/revisions"}],"predecessor-version":[{"id":19599,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/6083\/revisions\/19599"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media\/6084"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=6083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=6083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=6083"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=6083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}