Hi guys, I am new to the forum and looking forward to your help with my query. I am trying to create a stacked bar butterfly chart which is very challenging and I am not sure if it can be easily done. I have created a butterfly (Tornado) hart in Excel 2013, but I want to make each horizontal bar which is to the right and left sides of the graph, to display the top 4 highest figures that contribute to the overall length of each bar as its sements (i.e. turn the simple bar into stacked bar). Then, the remaining figures (i.e. outside the top 4 max values) for each bar can be summed up and be shown as another segment of the stacked bar. How I have to achieve this.
Example:
a1 = 28 (made up of 6, 4, 3, 5, 2, 1, 7) top 4 max figures are: 7, 6, 5, 4 the reminingg summed up to 6 (i.e. 1+2+3)
a2 = 30 (made up of 6, 3, 1, 4, 5, 2, 9) top 4 max figures are: 9, 6, 5, 4 the remaining summed up to 6
b1 = 24 (made up of 3, 1, 4, 5, 8, 1, 2) top 4 max figures are: 8, 5, 4, 3 the remianing summed up to 4
b2 = 17 (made up of 1, 3, 6, 0, 2, 4, 1) top 4 max figures are: 6, 4, 3, 2 the remaining summed up to 2
I would like a1 and a2 to be in the right hand side of the butterfly chart; and b1 and b2 in the left hand side of the chart. Then, for example for a1=28 (horizontal bar) I would like to be converted to a stacked bar to show its four highest composing figures i.e. 7, 6, 5, 4 as well as the sum of the remaining figures i.e. 3+2+1=6 as the segments f the a1 bar. Therefore, a1 bar now should show 5 segments as a stacked bar. Similarly for a2, b1, and b2 bras in the graph.
I appreciate your expert assistance with this query.
Simon