{"id":10216,"date":"2020-06-09T17:25:26","date_gmt":"2020-06-09T09:25:26","guid":{"rendered":"https:\/\/www.finereport.com\/en\/?p=10216"},"modified":"2021-01-14T11:12:43","modified_gmt":"2021-01-14T03:12:43","slug":"data-visualization-how-to-choose-the-right-chart","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2020\/06\/09\/data-visualization-how-to-choose-the-right-chart\/","title":{"rendered":"Data Visualization &#8211; How to Choose the Right Chart?"},"content":{"rendered":"<p>Now you get a data table from your boss, what are you going to do to process the data and make your boss satisfied?<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/06\/excel-easy.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-10217\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/06\/excel-easy.png\" alt=\"\" width=\"604\" height=\"341\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2020\/06\/excel-easy.png 604w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2020\/06\/excel-easy-300x169.png 300w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">From <a href=\"https:\/\/www.excel-easy.com\/\">Excel Easy<\/a><\/p>\n<p>Using the pivot table or Excel chart to show them better? It&#8217;s maybe a good idea, but this may take a lot of time&#8230; What about this?<\/p>\n<p>Let&#8217;s look at the following\u00a0dashboard together. Isn\u2019t it very cool? How many types of charts can you name?<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/06\/manufacturing.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-10218\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2020\/06\/manufacturing.png\" alt=\"\" width=\"1600\" height=\"1000\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2020\/06\/manufacturing.png 1600w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2020\/06\/manufacturing-300x188.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2020\/06\/manufacturing-768x480.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2020\/06\/manufacturing-1024x640.png 1024w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Manufacturing Command Room Made by FineReport<\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>What is the best way for others to understand your data? For me, it\u2019s data visualization. You have to admit that the above dashboard makes the data vivid and clear, much stronger than Excel.<\/p>\n<p>Now you know the charm of data visualization. However, how to choose the right chart to show your data is the most important thing. If you choose the wrong chart, it may give others some misunderstandings.<\/p>\n<p>Next, I will teach you how to choose the right chart from my prospect of view.<\/p>\n<h2><strong><b>Choosing the Right Chart to Make Data Visualization<\/b><\/strong><\/h2>\n<p>I will tell you the top 8 types of charts and their points for attention.<\/p>\n<h3>Column Chart<\/h3>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072203A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8906\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072203A.gif\" alt=\"\" width=\"941\" height=\"427\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<h4>Ramification &#8211; Stacked Column Chart<\/h4>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072202A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8905\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072202A.gif\" alt=\"\" width=\"941\" height=\"489\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>Advantages: The column chart uses the height of the column to clearly reflect the difference in data. In general, it is used to reflect the comparison between classified items, and it can also be used to reflect the time trend.<\/p>\n<p>Note: The limitation of the column chart is that it is only suitable for small and medium-sized data sets, and it is not easy to distinguish when there is more data. Generally speaking, no more than 10.<\/p>\n<p>Generally speaking, the horizontal axis of the bar chart is the time dimension, and users habitually believe that there is a time trend. If the horizontal axis is not a time dimension, it is recommended to distinguish each column by color.<\/p>\n<h3><strong><b>Line Chart<\/b><\/strong><\/h3>\n<p><strong><b><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072206A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8909\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072206A.gif\" alt=\"\" width=\"950\" height=\"453\" \/><\/a>\u00a0<a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072207A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8910\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072207A.gif\" alt=\"\" width=\"925\" height=\"438\" \/><\/a><\/b><\/strong><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>Advantages: Line charts are used to reflect trends over time. This graph is often used when we need to describe the change of things with time dimension.\u00a0Line charts are great for data comparing.<\/p>\n<h4><strong>Ramification &#8211; Area Chart<\/strong><\/h4>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072208A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8911\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072208A.gif\" alt=\"\" width=\"941\" height=\"427\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>Fill the shadow below the line chart to form an area chart. If there are two or more line charts, fill in the shades of different colors below the respective line to form a stacked area chart to facilitate understanding the relative proportion of the line chart.<\/p>\n<h3>Pie Chart<\/h3>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072211A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8919\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072211A.gif\" alt=\"\" width=\"890\" height=\"682\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>Note: The pie chart is a chart that should be avoided because the naked eye is not sensitive to the size of the area. But when it reflects a specific gravity, it will have a better effect if it is matched with a specific value.<\/p>\n<p>When you need to compare data, especially when comparing more than two whole components, be sure to use a bar chart or a column chart. Do not ask the person who reads the picture to convert the fan shape into data and compare them in the pie charts. Cause the human eye is insensitive to the size of the area, it may cause misreading of the data.<\/p>\n<p>In addition, in order to maximize the effect of the pie chart, it should generally not exceed 6 parts in use. If you need to express more than 6 parts, please also use a bar chart. It will be clearer.<\/p>\n<h4>Rose Chart<\/h4>\n<p>By the way, you may have seen the following chart &#8211; rose chart, it is beautiful while it is perhaps the most confusing chart, you should know that most data can&#8217;t be made into a beautiful rose chart, data often needs to be indexed to form a more beautiful rose chart.<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072210A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8918\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072210A.gif\" alt=\"\" width=\"592\" height=\"443\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<h3>Scatter Plot<\/h3>\n<p>The data of the scatter plot is three-dimensional data. Two sets of data are used to form multiple coordinate points. The distribution of the coordinate points is analyzed to determine the association or distribution trend between the two variables.<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072212A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8920\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072212A.gif\" alt=\"\" width=\"941\" height=\"418\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>The series can be distinguished by color, or the third dimension can be determined by the size of the scatter point, which leads to the bubble chart.<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072214A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8923\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072214A.gif\" alt=\"\" width=\"923\" height=\"528\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>The bubble chart is a derivative of the scatter chart. The third dimension is measured by the area of each point. It is suitable for the comparison of three-dimensional data, and the third dimension needs to be emphasized. It is not applicable if it exceeds three dimensions.<\/p>\n<h3>Radar Chart<\/h3>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072216A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8932\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072216A.gif\" alt=\"\" width=\"492\" height=\"413\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>The radar chart is suitable for multi-dimensional data (more than four dimensions), and each dimension must be sortable. There are usually about 6 data points. If there are too many data points, it is difficult to distinguish them.<\/p>\n<h3>Word Cloud Chart<\/h3>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072222A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8943\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072222A.gif\" alt=\"\" width=\"1302\" height=\"478\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p>The word cloud chart mainly displays text information, and visually highlights &#8220;keywords&#8221; that appear frequently, and is often used to compare the frequency of text occurrences. Such as user portrait tags, search keyword frequency, news keyword frequency.<\/p>\n<h3>Map<\/h3>\n<p>Geographic maps can be used for all analyses related to spatial attributes. For example, the sales volume in various regions, or the density of shops in a commercial area. The color depth or bubble size is generally used to show the numerical value of the area. For example, population density, sales volume by region, or store density in a commercial area.<\/p>\n<p>Maps are very attractive data visualization in these charts.<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072226A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8952\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072226A.gif\" alt=\"\" width=\"932\" height=\"498\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072227A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8955\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072227A.gif\" alt=\"\" width=\"905\" height=\"494\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072228A.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8956\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072228A.gif\" alt=\"\" width=\"905\" height=\"494\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<h3>Funnel Chart<\/h3>\n<p>It is often used to analyze the path of user churn and is a very practical chart.<\/p>\n<h2><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072221A.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8938\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/2019072221A.png\" alt=\"\" width=\"1984\" height=\"772\" \/><\/a><\/h2>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<h2><strong><b>Four<\/b><\/strong><strong><b>\u00a0B<\/b><\/strong><strong><b>asic <\/b><\/strong><strong><b>P<\/b><\/strong><strong><b>rinciples of <\/b><\/strong><strong><b>D<\/b><\/strong><strong><b>ata Visualization<\/b><\/strong><\/h2>\n<p>Finally, if you wanna make a dashboard, you should know the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Visual_design_elements_and_principles\">4 basic principles of design<\/a>.<\/p>\n<ul>\n<li>Comparison<\/li>\n<li>Composition<\/li>\n<li>Distribution<\/li>\n<li>Relationship<\/li>\n<\/ul>\n<p>Although it\u2019s very basic, follow them and I am sure you can make beautiful data visualization. Just like this<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/cover.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8829\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/12\/cover.png\" alt=\"\" width=\"2392\" height=\"1294\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/12\/cover.png 2392w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/12\/cover-300x162.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/12\/cover-768x415.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/12\/cover-1024x554.png 1024w\" sizes=\"(max-width: 2392px) 100vw, 2392px\" \/><\/a><\/p>\n<p><a style=\"color: #fff; background-color: #2849f7; border: none; border-radius: 20px; width: 140px; height: 40px; font-size: 16px; line-height: 26px; display: inline-block; padding: 6px 12px; margin-bottom: 0; text-align: center;\" href=\"\/en\/activation\">Free Trial<\/a><\/p>\n<h2>Summary<\/h2>\n<p>You can roughly understand how to choose the appropriate chart according to your data from this article. Only the data visualization with practical significance can really bring out the value of the data.<br \/>\nAll charts in this article come from FineReport, the personal version is completely free.<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/activation\"><img loading=\"lazy\" class=\"aligncenter wp-image-9249 size-full\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/09\/FR-visualization-.png\" alt=\"\" width=\"1720\" height=\"566\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/09\/FR-visualization-.png 1720w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/09\/FR-visualization--300x99.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/09\/FR-visualization--768x253.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/09\/FR-visualization--1024x337.png 1024w\" sizes=\"(max-width: 1720px) 100vw, 1720px\" \/><\/a><\/p>\n<div class=\"post-title\">\n<div class=\"post-title\">\n<p class=\"entry-title\">\n<\/div>\n<div class=\"post-content\">\n<div id=\"toc_container\" class=\"toc_light_blue no_bullets\"><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>We all know the importance of data visualization, but do you really know how to visualize your data? By using the right chart, you can make your data show its value in a vivid way.<\/p>\n","protected":false},"author":1,"featured_media":10218,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[854],"tags":[118],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/10216"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=10216"}],"version-history":[{"count":8,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/10216\/revisions"}],"predecessor-version":[{"id":11376,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/10216\/revisions\/11376"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media\/10218"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=10216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=10216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=10216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}