{"id":8722,"date":"2019-11-19T11:26:10","date_gmt":"2019-11-19T03:26:10","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=8722"},"modified":"2020-12-08T16:19:47","modified_gmt":"2020-12-08T08:19:47","slug":"dynamic-charts-make-your-data-move","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2019\/11\/19\/dynamic-charts-make-your-data-move\/","title":{"rendered":"Dynamic Charts: Make Your Data Move"},"content":{"rendered":"<h2><strong>How Dynamic Charts Work?<\/strong><\/h2>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/01.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8723\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/01.gif\" alt=\"\" width=\"1188\" height=\"621\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Made by FineReport<\/p>\n<p>The above picture is a dashboard made by FineReport that contains dynamic charts. By clicking the corresponding position of the pie chart, you can display the data of the specific area, which is more interactive.<\/p>\n<p>Let&#8217;s compare the data presented by Excel. Is it suddenly monotonous and cold? This is the most intuitive experience that dynamic charts can bring. Next, I will give you a clearer understanding of dynamic charts from the definition, advantages and production methods.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/02.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8724\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/02.png\" alt=\"\" width=\"1250\" height=\"262\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/02.png 1250w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/02-300x63.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/02-768x161.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/02-1024x215.png 1024w\" sizes=\"(max-width: 1250px) 100vw, 1250px\" \/><\/a><\/p>\n<h2><strong>What are Dynamic Charts?<\/strong><\/h2>\n<p>Don&#8217;t think that only if the chart can move, then it is a dynamic report, the accurate definition of the dynamic report refers to a report that does not have a fixed report template and needs to generate a template according to the actual business data. The core of the dynamic charts is that the data and chart types can be instantly displayed according to different conditions. In addition to showing the general static chart content, it must also have good interactivity.<\/p>\n<p>In simple terms, the core of dynamic charts is that the report data can be called at any time. For example, if the boss wants to view the data of a certain month, he only needs to set a parameter filtering condition. When the boss selects the time and month in the control, the report will only display the data of which month. This is called a dynamic report.<\/p>\n<p>The purpose of dynamic reports is to query and read data more conveniently and quickly. On this basis, dynamic reports need to contain a lot of logical functions, such as:<\/p>\n<p><strong>Parameter Filtering<\/strong>: Different conditions, the data you see is different, this is the basic function of dynamic reports.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/03.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8725\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/03.gif\" alt=\"\" width=\"1148\" height=\"538\" \/><\/a><\/p>\n<p><strong>Parameter Linkage<\/strong>: Link two or more components to achieve an automatic association between data. For example, click on the year sales, the order details of the year, the monthly return rate and the sales ranking will be linked.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/04.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8726\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/04.gif\" alt=\"\" width=\"1190\" height=\"626\" \/><\/a><\/p>\n<p><strong>Drill Down<\/strong>: The <a href=\"https:\/\/www.finereport.com\/en\/reporting-tools\/dynamic-reports-interactive-reports.html\">common functions of dynamic reports<\/a> are mainly to achieve the expansion of infinite layer data and to expand the detailed data with higher dimensions. For example, the drill-down map.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/05-1.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8727\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/05-1.gif\" alt=\"\" width=\"1190\" height=\"626\" \/><\/a><\/p>\n<p><strong>Parameter Panel Dynamic Display<\/strong>: Due to some needs, in many cases, certain query conditions are required when certain conditions are met. For example, if you select a region, the subsequent parameter box will automatically display the city and consumers in the region.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/06.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8728\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/06.gif\" alt=\"\" width=\"1190\" height=\"626\" \/><\/a><\/p>\n<p><strong>Dynamic Query<\/strong>: If there are multiple tables in the database, how to improve query efficiency? At this point, you can set the dynamic data column, enter &#8220;jia&#8221; in the control, it will display the information with &#8220;jia&#8221; in all the tables:<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/07.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8729\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/07.gif\" alt=\"\" width=\"1190\" height=\"626\" \/><\/a><\/p>\n<h2>How to Make a Cool Dynamic Chart?<\/h2>\n<p><strong>Basic Chart Production Process<\/strong><\/p>\n<p>In FineReport, the chart&#8217;s workflow is similar to Excel, Data Preparation &#8211; Insert Chart &#8211; Select Chart Type &#8211; Select Category Axis, Series Name and Series Value &#8211; Set Chart Style.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/\u5236\u56fe\u6d41\u7a0b.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8735\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/\u5236\u56fe\u6d41\u7a0b.png\" alt=\"\" width=\"1500\" height=\"532\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/\u5236\u56fe\u6d41\u7a0b.png 1500w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/\u5236\u56fe\u6d41\u7a0b-300x106.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/\u5236\u56fe\u6d41\u7a0b-768x272.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/\u5236\u56fe\u6d41\u7a0b-1024x363.png 1024w\" sizes=\"(max-width: 1500px) 100vw, 1500px\" \/><\/a><\/p>\n<p><strong>\u00a0<a href=\"http:\/\/www.finereport.com\/en\/data-visualization\/top-16-types-of-chart-in-data-visualization.html\">Different charts<\/a><\/strong><\/p>\n<p>The table is mainly about the beauty of words, numbers, and grids, as well as the overall color harmony. These can be customized in FineReport.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/08-1.png\"><img loading=\"lazy\" class=\"aligncenter wp-image-8730\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/08-1.png\" alt=\"\" width=\"722\" height=\"347\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/08-1.png 2070w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/08-1-300x144.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/08-1-768x369.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/08-1-1024x492.png 1024w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/a><\/p>\n<p>You can even make a card column report, is it very special?<a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/09.png\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-8731\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/09.png\" alt=\"\" width=\"1900\" height=\"1220\" srcset=\"https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/09.png 1900w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/09-300x193.png 300w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/09-768x493.png 768w, https:\/\/frg.fineres.com\/en\/wp-content\/uploads\/2019\/11\/09-1024x658.png 1024w\" sizes=\"(max-width: 1900px) 100vw, 1900px\" \/><\/a><\/p>\n<p><strong>Data Visualization Widgets<\/strong><\/p>\n<p>In order to highly integrate the process of data analysis, better understand the business meaning behind the data. In addition to the type of forms, visual charts still have a dynamic display part, it is called dynamic visualization.<\/p>\n<p><a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/10.gif\"><img loading=\"lazy\" class=\"aligncenter wp-image-8732\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/10.gif\" alt=\"\" width=\"406\" height=\"318\" \/><\/a> <a href=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/11.gif\"><img loading=\"lazy\" class=\"aligncenter wp-image-8733\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/11.gif\" alt=\"\" width=\"255\" height=\"212\" \/><\/a><\/p>\n<p><strong>Dashboards<\/strong><\/p>\n<p>If you want the final product to achieve the satisfaction of your boss, keep in mind four points:<\/p>\n<p>-Set the layout<\/p>\n<p>-Match colors<\/p>\n<p>-Decorate<\/p>\n<p>-Dynamic effects<\/p>\n<p>Then let us see the effect of <a href=\"http:\/\/www.finereport.com\/en\/data-visualization\/how-beginners-make-a-cool-dashboard%ef%bc%9f.html\">a cool dashboard<\/a>.<\/p>\n<p><a href=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/12-1.gif\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-10627\" src=\"https:\/\/www.finereport.com\/en\/wp-content\/uploads\/2019\/11\/12-1.gif\" alt=\"\" width=\"1185\" height=\"627\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Made by FineReport<\/p>\n<h2><strong>Tools to Make Dynamic Charts<\/strong><\/h2>\n<p>Finally, for different roles in the company, they usually use different tools to create dynamic charts to<a href=\"https:\/\/www.finereport.com\/en\/data-visualization\/data-visualization-2.html\" target=\"_blank\" rel=\"noopener noreferrer\"> visualize data<\/a> according to their work needs. These three scenarios are the most common and wish can give you some reference.<\/p>\n<p>&#8211; Use Excel&#8217;s built-in charts to do some regular charts. Advanced complex charts made by Excel such as dynamic charts, filtering display of charts can be achieved by writing VBA;<\/p>\n<p>-Using the coding language of R, Python, calling the chart function package, presenting the visual data, commonly used for <a href=\"http:\/\/www.finereport.com\/en\/data-analysis\/6-key-skills-that-data-analysts-need-to-master.html\">data analysts<\/a>;<\/p>\n<p>&#8211; Using <a href=\"https:\/\/www.finereport.com\/en\/data-visualization\/free-and-open-source-data-visualization-tools.html\" target=\"_blank\" rel=\"noopener noreferrer\">open-source visual plugins<\/a> such as Echarts, HighCharts, D3.js, embedding code, developing plug-in packages, often used by visual engineers and front-end development.<\/p>\n<h2 class=\"graf graf--h3\">You might also be interested in\u2026<\/h2>\n<p class=\"entry-title\"><a href=\"http:\/\/www.finereport.com\/en\/data-visualization\/how-beginners-make-a-cool-dashboard%ef%bc%9f.html\">How Beginners Make a Cool Dashboard\uff1f<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/www.finereport.com\/en\/reporting-tools\/data-reporting.html\">A guide to take your data reporting to another level<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/www.finereport.com\/en\/data-visualization\/what-is-data-visualization-for-large-screen-and-how-to-implement-it.html\">What is Data Visualization for Large Screen and How to Implement It?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you still work with static data to create charts, this article will teach you how to create dynamic charts to make your data move.<\/p>\n","protected":false},"author":1,"featured_media":8723,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[854],"tags":[126,118],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/8722"}],"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=8722"}],"version-history":[{"count":11,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/8722\/revisions"}],"predecessor-version":[{"id":11276,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/8722\/revisions\/11276"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media\/8723"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=8722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=8722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=8722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}