If you want the value with the percentage click on both and close it. This will open up the Format Data Label option on the right side of your worksheet. To do this select the More Options from Data labels under the Chart Elements or by selecting the chart right click on to the mouse button and select Format Data Labels. # Formatting Data Labels Of The Pie Chart To select a single slice, click on it, and then click it again so that only this slice is selected. To draw your users’ attention to a certain slice of a pie, you can move it out from the rest of the pie chart.Īnd again, the quickest way to pull out an individual slice is to select it and drag away from the center using the mouse. Pulling out a single slice of a pie chart Or, type the desired number directly in the percentage box: On the Format Data Series pane, switch to the Series Options tab, and drag the Pie Explosion slider to increase or decrease gaps between the slices.Right-click any slice within your Excel pie graph, and select Format Data Series from the context menu.In Legend, type #PERCENT for the Custom legend text property. The Series Properties dialog box displays. On the design surface, right-click on the pie chart and select Series Properties. To display percentage values in the legend of a pie chart (Optional) To specify how many decimal places the label shows, type "#PERCENT". The Series Label Properties dialog box appears. On the design surface, right-click on the labels and select Series Label Properties. The data labels should appear within each slice on the pie chart. On the design surface, right-click on the pie and select Show Data Labels. For more information, see Add a Chart to a Report (Report Builder and SSRS). To display percentage values as labels on a pie chartĪdd a pie chart to your report.
The Tutorial: Add a Pie Chart to Your Report (Report Builder) walks you through adding percentages to pie slices, if you'd like to try this with sample data first. You may also want percentages in the legend or the pie slices themselves.
In paginated reports, by default the legend shows categories.
0 kommentar(er)
