Uncheck the box next to the Value box.This will add the Race/ethnicity labels as well as the percentage data to the pie chart. Check the boxes for Category Name and Percentage in the Label Options section in the Format Data Labels pane.This will open the Format Data Labels pane on the right. Now, you can right click one of the numbers and select Format Data Labels from the list.This will add the values for each of the slices in the pie. Right click any of the slices in the pie chart, and select Add Data Labels from the list.A pie chart typically shows labels next to each slice. Click the chart legend once and press the DELETE key on your keyboard.Resize the pie chart so the left side is locked to the left side of Column E, the right side is locked to the right side of Column L, the top is locked to the top of Row 2, and the bottom is locked to the bottom of Row 10 (see Figure 4.19).Click and drag the pie chart so the upper left corner is in the middle of cell E2.Click off the slices and into the white canvas to deselect the pie and select the entire chart.Use the Undo button to undo this if you want to try again. This can be another option for displaying your data. This would not show Value and Percent(%) at the same time, but allows the user toggle between either option.Note: if you let go of the mouse button before dragging, you may only get one slice to move when you drag it out from the center. Remember to raise your default chart to the front so it appears upon selection of "All Values" on the Input Control (i.e. On each of the charts, enable "Hide When" using the variable to show either chart upon selection of either option on the Input Control Create an Input Control based on the variable with custom lov ("Show Values", "Show Percent Share")Ħ. Place the copy directly on top of the originalĤ. Leave the background on both charts opaque rather than translucentģ. Create a copy of the pie chart as suggested above, and have either chart display percent or values (either inside or outside the chart - I prefer outside on both, as small slices tend to hide numbers when shown inside)Ģ. Where the above solution doesn't work because as described, the user needs to drill up and down a related dimension hierarchy, I would suggest the following compromise - a toggle between value and %:ġ. I have the title shown on both charts to give a better understanding of the You might have to re size the Pie Chart with percentages to getĪ correct fit giving a perception of a single Pie Chart as shown below. 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.ġ.
How to make a pie chart in excel given percentages pdf#
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.