Displaying percentages as a series in an Excel chart

Line spacing

1. Select the text you want to format.
2. On the Home tab, locate the Paragraph group, then click the Line Spacing command.
3. Select the desired line spacing from the menu that appears. Changing the line spacing.

To determine the percentage, we have to divide the value by the total value and then multiply the resultant to 100. Percentage formula = (Value/Total value)×100. Example: 2/5 × 100 = 0.4 × 100 = 40 per cent.

Select the decimal number cells, and then click Home > % to change the decimal numbers to percentage format. 7. Then go to the stacked column, and select the label you want to show as percentage, then type = in the formula bar and select percentage cell, and press Enter key.

Count and Percentage in a Column Chart

1. Select values placed in range B3:C6 and Insert a 2D Clustered Column Chart (Go to Insert Tab >> Column >> 2D Clustered Column Chart).
2. In cell E3, type =C3*1.15 and paste the formula down till E6.
3. In cell F3, type the following formula and paste the formula down till F6.

1. Select the data labels and data. In this case, you’d select A1:D5.
2. Then, click the Chart Wizard on the Standard toolbar.
3. Choose Bar as the Chart Type, click the Stacked Bar subtype, and click Next.
4. For this chart, choose Rows as the series source and click Finish.

All selected numbers have been changed to percentage format. #9 select one data label in the stacked column chart, and then type = in the formula bar, and then select percentage value, and press Enter key.

To display percentage values as labels on a pie chart

1. Add a pie chart to your report.
2. On the design surface, right-click on the pie and select Show Data Labels.
3. On the design surface, right-click on the labels and select Series Label Properties.
4. Type #PERCENT for the Label data option.