Exclude zero values from chart

Hi guys/gurls I have attached an example to help. What i am trying to achieve is not have space for departments with zero value as it takes up space and from chart it doesnt seem that clear what department it is refering. If anyone could help me on this it would be much appreciated.

I would also like this chart to be replicated on varous others costs with same format e.g. fuel if there is a vba or macro that i can be helped with.

Thanks