Pie chart over exceeded

[emmatm]

Hi, I have a bar char on my attached file (master tab), the second pie 'Agile desks'.
Is there a way to see visually that this number has been exceeded?
Perhaps a better diagram is needed - any suggestions?

 

[Luke M]

Maybe something like this?


Assuming intent is to show how much of each item is being used. I did a basic bar chart, set the x-axis to use 1 (100%) as the minor unit, and formatted Agile bar to be red. I even added an IF statement to the right of my data with this formula:
=IF(Q47>1,"Over-crowded","")
and then linked it to the data labels.

 

[NARAYANK991]

Hi Luke ,

You can also use a Custom Format for the Data Labels , as follows :

[<=1]"";[>1]"Overcrowded"

Narayan