HOW TO DIRECTLY LABEL STACKED COLUMN CHARTS IN EXCEL

CREATE AWSOME CHARTS

6. Click the Ok button to close the Edit Series dialog box.
7. Click the Ok button to close the Select Data Source dialog box.
8. While the chart is still selected, click the Change Chart Type icon in the Type group under the Chart Design tab.
9. In the Change Chart Type dialog box, select Combo under the All Charts tab.
10. Next, under the Choose the chart type and axis for your data series set the Chart Type to Scatter for the Labels data series as per the below screenshot:

11. Press the Ok button to close the Change Chart Type dialog box. The chart should look like this:

15. Click the Ok button to close the Edit Series dialog box.
16. Click the Ok button to close the Select Data Source dialog box.
17. In the chart, right-click the "Labels" series and then, on the shortcut menu, select Add Data Labels.
18. Next, select the newly added data labels and then, in the Format Data Labels pane, under Label Options, click the Value From Cells under Label Contains.
19. In the Data Label Range dialog box refer to the range B2:E2 in the Select Data Label Range edit box.
20. Click the Ok button to close the Data Label Range dialog box. Uncheck the Y values and Show Leader Lines options.
21.Next, under Text Options, click the Textbox icon and set all Margins to 0 and uncheck the Wrap text in shape option.
The chart should look like this:

22. Finally, delete the legend.
23. Set the Total label font to Bold. Change the color of Product C label to orange.
24. Set the Shape Fill color of Product A and Product B data series to light grey. The chart should look like this:

Next, we need to prepare the setup for the position of the labels. For that we'll use scatterplots.

1. Enter the following labels "x", and "y" in cells A13 and A14 respectively.
2. Enter the following formulas in the respective cells:
B13 --> = COUNTA(A3:A10) + 0.3
C13 -->  = B13
D13 -->  = B13
E13 -->  = B13
B14 -->  = B10 / 2
C14 -->  = B10 + C10 / 2
D14 -->  = B10 + C10 + D10 / 2
E14 -->  = E10 + 3.3

The worksheet should look like this:

12. On the worksheet, right-click the chart and then, on the shortcut menu, click Select Data.
13. Next, In the Select Data Source dialog box, select the Labels data series click on the Edit button under Legend Entries (Series).
14. In the Edit Series dialog box, edit the Series X values to refer to the range B13:E13 and the Series Y values to refer to the range B14:E14 as per the below screenshot:

Thank you for reading, and I hope you found this useful. If you have any questions, find me on Twitter and ask me anything.