creating a pie chart in excel with percentages

❸ From the Charts group, select any one of the graph samples. ❷ Then go to the Insert tab from the main ribbon. If you want to change the graph axis format from the numbers to percentages, then follow the steps below: Read More: How to Show Percentage in Excel Pie Chart (3 Ways)Ģ. When you are done, you will see percentages showing up in the stacked column chart instead of showing the general numerical values. ❽ Now repeat the same process to convert all of the numbers into their corresponding percentages.

Then you will see percentages is showing instead of numerical values. ❻ Then click one of the data labels of the stacked column chart, go to the formula bar, type equal (=), and then click on the cell of its percentage equivalent. ❺ Create one secondary data table and convert all the general numerical values into percentages. To display percentage instead of the general numerical value, ❹ After that navigate to Chart Design > Add Chart Element > Data Labels > Center.Īt this point, you will have data labeled in the stacked column chart. ❸ After that from the Charts group, select a stacked column chart as shown in the screenshot below: ❶ Select the range of cells that you want to consider while plotting a stacked column chart. However, if you want to display a percentage in a stacked column chart instead of showing them using general numerical values, then follow the steps below.

You can generate a stacked column chart using general numbers in Excel. Show Percentage in a Stacked Column Chart in Excel Display Percentage in an Excel Graph.xlsxģ Methods to Display Percentage in Excel Graph 1.

Creating a pie chart in excel with percentages