And then you need to make the line chart invisible, right click the line, and select Format Data Series. In the Format Data Labels pane, under the Label Options tab, and check the Above option in the Label Position section. Go ahead to select the data labels, right click, and choose Format Data Labels from the context menu, see screenshot:Ħ. And the data labels stay at upper-right corners of each column.ĥ. See screenshot:Īnd now each label has been added to corresponding data point of the Total data series. Select and right click the new line chart and choose Add Data Labels > Add Data Labels from the right-clicking menu. Now the Total data series has been changed to the line chart type. In the Change Chart Type dialog box, click the Chart Type drop-down list of the Total data series, select Line from the drop-down list, and then click the OK button. Then right click the Total series and select Change Series Chart Type from the right-clicking menu.ģ. See screenshots:Īnd now a stacked column chart has been built.Ģ. Firstly, you can create a stacked column chart by selecting the data that you want to create a chart, and clicking Insert > Column, under 2-D Column to choose the stacked column. Supposing you have the following table data.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |