Stacked chart and line value



I am trying to create a chart that combines stacked columns for a set of series and line value for a single serie. The purpose is to visually display the different components (and their absolute value) of a specific bill. As line value, I want to display the total value of my stacked columns (or total bill).

I am using Multiple Axes Chart as I can use patterns for data series, which is essential to my work.

Is there any way to get to this results (as illustrated by the uploaded picture from Excel)?

Asked question