100% stacked bar chart and absolute Total on Top of bars

Hi All,

I hope you are doing fine.

I have create a 100% stacked bar chart, that displays absolute values within bars.

Now I need to have the Total at top, but bars should stay as it is.

Workbook is example. If I add a reference line in my original chart, bars won't show because total would be too high.

Is there a different way to get totals?

For any hints I am really thankful.

Best regards

Sabine