Excel Dashboard: Attempt to integrate Boxplot (clusted bar chart) into KPI Display (stacked bar)
Hello all,
I am quite new on this forum so I hope I will not directly walk into a faux-pas. Recently I am working on this excel file that I found on the internet, that has a Dashboard incorporated into it displaying KPIs.
Although the file is great there was one function I wanted to change, that is to have a Box-Plot function that also displays the 10 KPI-Values that are momentarily shown in the Dashboard.
However, I just can't get it to work. Part of the problem seems to be that the original graph is a stacked bar chart. My Boxplot on the other hand is a clustered bar chart. What I am trying to accomplish is to combine both functions so to achieve a Boxplot where one can scroll through the Boxplot values. I was thinking to achieve this by using a secondary axis to achieve both a stacked and the clustered Bar Chart into one. However with no success so far I really need some help.
I hope my explanation makes some sense. Otherwise I have added my Excel File with the Dashboard and the attempt I have made with the Boxplot so far.
I would really appreciate some support on this one and already thanks in advance for your help.
Kind regards
Robin
|