{"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":"2019-05-23T14:21:55","modified_gmt":"2019-05-23T06:21:55","slug":"how-to-make-a-pie-of-pie-chart-or-bar-of-pie-chart","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/12\/23\/how-to-make-a-pie-of-pie-chart-or-bar-of-pie-chart\/","title":{"rendered":"How to make a pie of pie chart or bar of pie chart?"},"content":{"rendered":"\n

1. Problem description<\/strong><\/strong><\/h3>\n\n\n\n

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 FineReport<\/a> Designer, as shown below.<\/p>\n\n\n\n

Pie of Pie Chart<\/strong><\/h4>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n

Bar of Pie Chart<\/strong><\/h4>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n

2. Definition<\/strong><\/h3>\n\n\n\n

In 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

3. Example<\/strong><\/h3>\n\n\n\n

3.1 Open report<\/strong><\/h4>\n\n\n\n

Open the report: %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\3Darea.cpt<\/p>\n\n\n\n

3.2 Set percent data template<\/strong><\/h4>\n\n\n\n

The pie of pie chart and the bar of pie chart only split the series by percent value. Therefore, 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

3.3 Make pie of pie chart<\/strong><\/h4>\n\n\n\n

The example below illustrates how to make a pie of pie chart to help with data analysis. Select Chart. Check Chart Attribute Table \u2013 Style > 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>\n\n\n\n

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

As required, you can set Series Tag Style. Check the tags in the Chart Attribute Table \u2013 Style > Series. Select a value and set the format. The percent is rounded to two decimal places.<\/p>\n\n\n\n

3.4 Change chart data<\/strong><\/h4>\n\n\n\n

Change Legend Item (Series) value to C2 to complete setting of the pie of pie chart.<\/p>\n\n\n\n

3.5 Preview and save<\/strong><\/h4>\n\n\n\n

Save template. Click Page-breaking Preview to see the effect. <\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

For completed templates, see: <\/p>\n\n\n\n

%FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Advanced\\Chart\\3Darea_2.cpt<\/p>\n","protected":false},"excerpt":{"rendered":"

1. Problem description When several data points in the …<\/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],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/4305"}],"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=4305"}],"version-history":[{"count":5,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/4305\/revisions"}],"predecessor-version":[{"id":5717,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/4305\/revisions\/5717"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=4305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=4305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=4305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}