Pivot table bar diagram

I’m using Numbers to record how much and on what I’m spending money. I sort this into categories to get a better overview. I’m using a pivot table to summarise it according to category and year or month, I have both, which I then use a lying bar diagram to display.

My problem is that some expenses, rent mostly, is much bigger than others. It’s the equivalent of roughly $2’500 this year compared to $1’100 in the next biggest category, monthly the scale is adjusted to $700 when almost all the of the categories are under 100$ the majority of the time.

So, my question is: is there any way of limiting the scale of a lying bar diagram connected to a pivot table?