Line chart over stacked bar chart

[mikey1987]

Hello everyone,

I've tried quite some google searches, but I can't seem to find a solution for this.
What I want to do, is to build a stacked bar graph (that means the graph is horizontal, not vertical), and I somehow want the cumulative data labels over them.

So if my bar chart has this data:
5 / 10 / 20
I want that data used, but the headers over that data should be
5 / 15 / 35

I read somewhere to use a line chart, but make it invisible and only use the data labels, but I can't seem to figure out how to do that
(found that here: Cumulative Data Labels on Stacked Bar/Column Chart)

Can anyone tell me how I can make line charts that hover exactly over that stacked bar? I assume it has something to do with a secondary axis, but it doesn't work

Any advice would be greatly appreciated!

 

[Steve=True]

Hi Mikey1987

Here is a post that is very similar to your problem. Should work for a bar chart as well.

Link:
how-to-put-percentage-labels-on-top-of-a-stacked-column-chart

Hope this helps set you in the right direction.

Steve=True

 

[mikey1987]

Hi Mikey1987

Here is a post that is very similar to your problem. Should work for a bar chart as well.

Link:
how-to-put-percentage-labels-on-top-of-a-stacked-column-chart

Hope this helps set you in the right direction.

Steve=True

Hey Steve,

I found an alternative: I built data labels (so independent from the actual data) and used "x y chart labeler" add in.
did the trick!

thx,
Mikey