Creating A Pie Chart In Excel With Percentages. Jan 02 2019 Pie charts are great but they are difficult to visualize when they have many small slices. Select the data you will create a pie chart based on click Insert.
Percentages will be calculated by Excel automatically with the entire pie representing 100. In the Format Code field if you want to display percentages with a single decimal place. For instance six slices that make up 10 of the total.
After inserting the chart then you should insert two helper columns in the first helper column-Column D please enter this formula.
Insert Column or Bar Chart. Remove the decimal digits and set the format code 0. In your spreadsheet select the data to use for your pie chart. To show hide or format things like axis titles or data labels.
