I have a single bar that is 3-4 times larger than the 20-30 other bars and it makes everything much shorter.


Using primary axis max just makes it reach the top of the chart and doesn't convey it properly. (Not to mention it also puts the data label inside the bar and turns the text white)

I saw an excel tutorial to add a break in a bar but I doubt that is possible in access.
Any tips on how to deal with this?

I would prefer a modern chart as they look better but traditional charts are fine too.
(most bars are 200-1000. The odd one out is about 4000)

Thanks in advance!