how to create percentage pie chart in excel

In the Format Data Series pane, under the Series Options tab, select Secondary Axis from the Plot Series On section, and you will get the below screenshot shown:ĩ. Then, click OK button, this new data series has been inserted into the chart, and then, please right click the new inserted bar, and choose Format Data Series, see screenshot:Ĩ. And then, under the Series values section, select the data in the first helper column, see screenshot:ħ. In the Select Data Source dialog box, click Add button, see screenshot:Ħ. Then, select the created chart, and right click, choose Select Data from the context menu, see screenshot:ĥ. And then, in the second helper column, Column E, enter this formula: =B2&CHAR(10)&' ('&TEXT(C2,'0%')&')', and drag the fill handle down to the cells that you want to use, see screenshot:Ĥ. After inserting the chart, then, you should insert two helper columns, in the first helper column-Column D, please enter this formula: =B2*1.15, and then drag the fill handle down to the cells, see screenshot:ģ. Select the data range that you want to create a chart but exclude the percentage column, and then click Insert > Insert Column or Bar Chart > 2-D Clustered Column Chart, see screenshot:Ģ. To solve this task in Excel, please do with the following step by step:ġ. It is easy for us to add percentage or value to the bar or column chart, but, have you ever tried to create a column or bar chart with both percentage and value displayed in Excel?Ĭreate a chart with both percentage and value in ExcelĬreate a stacked chart with percentage by using a powerful feature How to create a chart with both percentage and value in Excel?

How to create percentage pie chart in excel