![how to make a pie chart in excel without know percentage how to make a pie chart in excel without know percentage](https://cdn.extendoffice.com/images/stories/doc-excel/create-pie-of-pie-chart/doc-pie-of-pie9.png)
But what were itching to do here is to show what percentage each wine type is of each suppliers sales, not of the total sales. Of course, this is how the pie chart has to behave because a pie chart must always show the ratio of the parts to the whole. Because of this, Ive had to display the legend so we can tell which colour is which supplier. 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:
![how to make a pie chart in excel without know percentage how to make a pie chart in excel without know percentage](https://image1.slideserve.com/1575878/slide5-l.jpg)
HOW TO MAKE A PIE CHART IN EXCEL WITHOUT KNOW PERCENTAGE SERIES
![how to make a pie chart in excel without know percentage how to make a pie chart in excel without know percentage](https://www.excelcampus.com/wp-content/uploads/2017/03/Add-Progress-Doughnut-Charts-to-a-Dashboard.png)
Right-click any slice within your Excel pie graph, and select Format Data Series from the context menu.