zapla.blogg.se

Notice how the detail labels show percentages for the Details rather than SUPPLIER. 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: