In the popped out Change Chart Type dialog box, in the Choose the chart type and axis for your data series list box, select Line chart type for the Total data series, see screenshot:ġ1. Then, click to select the total series data, and then right click, choose Change Series Chart Type from the context menu, see screenshot:ġ0. And then, click to select the chart, and click the Chart Elements icon to expand the Chart Elements list box, in the list box, check Data Labels to insert the data labels, see screenshot:ĩ. Then, you can delete the unwanted elements from the chart, such as chart title, gridlines, see screenshot:Ĩ. Click to select the chart, and then click Design > Switch Row/Column, and you will get a chart as below screenshot shown:ħ. A stacked chart has been inserted as below screenshot shown:Ħ. Now, select the original data including the total value cells, and then click Insert > Insert Column or Bar Chart > Stacked Column, see screenshot:ĥ. Now, you need to change the decimal values to percentage values, please select the formula cells, and then click Home > Percentage from the General drop down list, see screenshot:Ĥ. First, please calculate the total values for each column data, enter the below formula into cell B6, and then drag the fill handle from right side of the cells you want to apply the formula, see screenshot:ģ. Video: Create a stacked column chart with percentage valuesĬreate a stacked column chart with percentage valuesįor displaying both total values and percentage values in the stacked column chart, please do with the following steps:ġ.Download Stacked Column Chart With Percentage Values sample file.Create a stacked column chart with percentage values with an amazing feature.Create a stacked column chart with percentage values.How could you create this type of chart in Excel? But, sometimes, you may need the stacked column chart with percentage values instead of the normal values, and display the total values for each column at the top of the bar as below screenshot shown.
In Excel, it is easy for us to create a stacked column chart with data value labels.
Create stacked column chart with percentage
0 kommentar(er)
