Thread: Stacked data labels dynamic

I have created a stack column chart while displaying the totals using the secondary axis.

I would like to display the percentages in column H in a text box above the bar.

I know I can create a text box and then link to the source and it will display fine, but then if the data changes the text box is not dynamic.

How can I get this to be dynamic?

You do not need to use textboxes.

If you set the secondary axis category range to H2:H13 you can apply data labels displaying Category Name.

Change the chart type of Total series to clustered column and the labels can appear outside the top of the column.