excel_stuff
Member
Hi colleagues,
I am struggling with perhaps a simple dashboard question. I am trying to replicate bar charts in KPI dashboard - revisited II (available on chandoo.org). My minimum value and first quartile are below zero while median, third quartile and max are positive. I also have a target KPI and the score for the company in question (depicted using + sign). However, I am struggling to get it right and would appreciate help. Here are the numbers:
Min = -3
First quartile = -1.5
Median = 0.5
Third quartile = 1.5
Max = 3
Thank you!
I am struggling with perhaps a simple dashboard question. I am trying to replicate bar charts in KPI dashboard - revisited II (available on chandoo.org). My minimum value and first quartile are below zero while median, third quartile and max are positive. I also have a target KPI and the score for the company in question (depicted using + sign). However, I am struggling to get it right and would appreciate help. Here are the numbers:
Min = -3
First quartile = -1.5
Median = 0.5
Third quartile = 1.5
Max = 3
Thank you!