{"id":4305,"date":"2016-12-23T17:00:22","date_gmt":"2016-12-23T09:00:22","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=4305"},"modified":"2025-04-17T11:58:27","modified_gmt":"2025-04-17T03:58:27","slug":"how-to-make-a-pie-of-pie-chart-or-bar-of-pie-chart","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/how-to-make-a-pie-of-pie-chart-or-bar-of-pie-chart.html","title":{"rendered":"How to make a pie of pie chart or bar of pie chart?"},"content":{"rendered":"\n<div id=\"toc_container\" class=\"toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#1_Pie_Chart_Problem_Description\">1. Pie Chart Problem Description<\/a><ul><li><a href=\"#Pie_of_Pie_Chart\">Pie of Pie Chart<\/a><\/li><li><a href=\"#Bar_of_Pie_Chart\">Bar of Pie Chart<\/a><\/li><\/ul><\/li><li><a href=\"#2_Definition_of_Pie_Chart\">2. Definition of Pie Chart<\/a><\/li><li><a href=\"#3_Example_of_Pie_Chart\">3. Example of Pie Chart<\/a><ul><li><a href=\"#31_Open_report\">3.1 Open report<\/a><\/li><li><a href=\"#32_Set_percent_data_template\">3.2 Set percent data template<\/a><\/li><li><a href=\"#33_Make_pie_of_pie_chart\">3.3 Make pie of pie chart<\/a><\/li><li><a href=\"#34_Change_chart_data\">3.4 Change chart data<\/a><\/li><li><a href=\"#35nbspPreview_and_save\">3.5&nbsp;Preview and save<\/a><\/li><\/ul><\/li><\/ul><\/div>\n<h2><span id=\"1_Pie_Chart_Problem_Description\"><strong>1. Pie Chart<\/strong> <strong>Problem Description<\/strong><\/span><\/h2>\n\n\n\n<p>When several data points in the pie chart are smaller than 10% of the pie chart, it is difficult to distinguish the slices. To solve this problem, a secondary plot area is used to make a pie of pie chart or a bar of pie chart in&nbsp;<a href=\"http:\/\/www.finereport.com\/en\/\">FineReport<\/a> Designer, as shown below.<\/p>\n\n\n\n<h3><span id=\"Pie_of_Pie_Chart\"><strong>Pie of Pie Chart<\/strong><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019052301A.png\" alt=\"\"\/><\/figure>\n\n\n\n<h3><span id=\"Bar_of_Pie_Chart\"><strong>Bar of Pie Chart<\/strong><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019052302A.png\" alt=\"\"\/><\/figure>\n\n\n\n<h2><span id=\"2_Definition_of_Pie_Chart\"><strong>2. Definition<\/strong> of Pie Chart<\/span><\/h2>\n\n\n\n<p>In&nbsp;FineReport Designer, the pie of pie chart or the bar of pie chart separate small slices from the main pie chart and display them in a secondary plot area, which is called a secondary pie chart or a stacked bar chart. The percent values can be manually set.<\/p>\n\n\n\n<h2><span id=\"3_Example_of_Pie_Chart\"><strong>3. Example<\/strong> of Pie Chart<\/span><\/h2>\n\n\n\n<h3><span id=\"31_Open_report\"><strong>3.1 Open report<\/strong><\/span><\/h3>\n\n\n\n<p>Open the report: %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\3Darea.cpt<\/p>\n\n\n\n<h3><span id=\"32_Set_percent_data_template\"><strong>3.2 Set percent data template<\/strong><\/span><\/h3>\n\n\n\n<p>The pie of pie chart and the bar of pie chart only split the series by percent value. Therefore,&nbsp;we should calculate the percent of the payable in each region and hide Column B. Type percent in C1, and type formula: =B2\/SUM(B2[!0]) in C2, where B2[!0] is expanded from B2. As required, set the cell style.<\/p>\n\n\n\n<h3><span id=\"33_Make_pie_of_pie_chart\"><strong>3.3 Make pie of pie chart<\/strong><\/span><\/h3>\n\n\n\n<p>The example below illustrates how to make a pie of pie chart to help with&nbsp;data analysis. Select Chart. Check Chart Attribute Table \u2013 Style &gt; Secondary Plot Area in the Series. Change the percent value in the Secondary Plot Area to 10 (Default value: 5), indicating that the Secondary Plot Area contains all percent values smaller than this value, 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\/2019052303A.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Note: in the Secondary Plot Area, you may select a pie to make a pie of pie chart, or a bar to make a bar of pie chart.<\/p>\n\n\n\n<p>As required, you can set Series Tag Style. Check the tags in the&nbsp;Chart Attribute Table \u2013 Style &gt; Series. Select a value and set the format.&nbsp;The percent is rounded to two decimal places.<\/p>\n\n\n\n<h3><span id=\"34_Change_chart_data\"><strong>3.4 Change chart data<\/strong><\/span><\/h3>\n\n\n\n<p>Change Legend Item (Series) value to C2 to complete setting of the pie of pie chart.<\/p>\n\n\n\n<h3><span id=\"35nbspPreview_and_save\"><strong>3.5&nbsp;Preview and save<\/strong><\/span><\/h3>\n\n\n\n<p>Save template. Click Page-breaking Preview to see the effect.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/blogs\/images\/2019052304A.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>For completed templates, see: <\/p>\n\n\n\n<p class=\"has-text-align-left\">%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\3Darea_2.cpt<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contents1. Pie Chart Problem DescriptionPie of Pie ChartBar of Pie Chart2. Definition of Pie Chart3. Example of Pie Chart3.1 Open report3.2 Set percent data template3.3 Make pie of pie chart3.4 Change chart data3.5&nbsp;Preview and save 1. Pie Chart Problem Description When several data points in the pie chart are smaller than 10% of the pie&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[126,117],"yst_prominent_words":[610,605,601,608,595,592,604,600,596,633,611,632,594,591,609,598,607,597,593,606],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4305"}],"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=4305"}],"version-history":[{"count":5,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4305\/revisions"}],"predecessor-version":[{"id":19641,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/4305\/revisions\/19641"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=4305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=4305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=4305"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=4305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}