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

Attached Files

KPI Dashboard - revisited II.xlsx (117.4 KB, 12 views)