opktrax.blogg.se

How to create pie chart in excel with percentages
How to create pie chart in excel with percentages






how to create pie chart in excel with percentages

Align the Pie Chart with percentages on top of the original Pie Chart to get the below result. After Completing step 7 you should have two Pies as shown belowĩ. Select Global -> Background set the values as shown below.Ĩ. Change data position to Inside you should have the below values.ħ. Change the data type to Label and Percent or Percent depending on how you want the Labels to Appear.Ħ. Duplicate the Pie Chart that was just created and right click and select Format Chart on the second Pie Chart.ĥ. Drag both the Objects on the report and convert the table to a Pie Chart.ģ. Created a simple query with Year and Sales Revenue as the Result Objects.Ģ. This solution provides a work around for this issue.ġ. In BI 4.0 the values and percentages are displayed when you hover over the Pie but if a user were to use a static version of this where they either export it to Excel or PDF then either the Values or percentages can be shown but not both. The document address a solution to display values and percentages in a Pie Chart in Web Intelligence.








How to create pie chart in excel with percentages