Hi,
I want to show some data in an excel chart.
Currently I have 7 stacked columns plotted on the first vertical axis and and stacked column plotted on the second vertical axis.
Instead of the stacked column on the second vertical axis, I would like to make a stacked bar for each of the two stacks in the current stacked column plotted against the second axis. I want the height to be the same height as the stacked column on the second axis (the top of the bars should be at 0). With height I mean y-direction.
Each of the stacks in the stacked bars should be equal to a given value plotted against the first horizontal axis. The stacks are defined as Bottom 1 part 1/2/3 and Bottom 2 part 1/2. Please see attached workbook and picture for reference.
I hope this is possible in excel and that someone can help me.
Best regards
Bookmarks