Forum Discussion
How to create a multi-tiered percentage-based bar chart?
Hello,
I would like to create a multi-tiered percentage-based bar chart based on the data found below (test data evidently). Column B and C add up to 100%, Column D and E add up to 100%, and lastly column F and G add up to 100%. I would like each set of variables to equate to 100% on the graph, as the source data is percentage based anyways, but all be organized in their own separate row on the graph underneath the employee name. I have included a diagram drawn in MS paint to portray the desired output (with an accompanying legend). Thanks in advance!
| Employee Name | Number of Sales Made % | Number of Sales Made from Other Competitors % | Number of Calls Made % | Number of Calls Made from Other Competitors % | Number of Individual Employees % (always is 1) | Number of competitor employees % |
| John | 28.57% | 71.43% | 30.00% | 70.00% | 16.67% | 83.33% |
| Stacy | 41.67% | 58.33% | 38.71% | 61.29% | 20.00% | 80.00% |
| Richard | 47.06% | 52.94% | 47.06% | 52.94% | 14.29% | 85.71% |
| Andy | 42.31% | 57.69% | 40.48% | 59.52% | 10.00% | 90.00% |
1 Reply
I've applied Power Query to convert the blue table into the green result table. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table. The stacked bar chart is updated dynamically.
