Trimming bar in Column chart

[RafaelAri]

You know the situation where there is a bar graph, the data in which is, for example, the amount of items in stock. Let's assume that almost all the items are in quantities up to 1000 pcs. Then there is an item or two, with a quantity of 100,000, and they distort the whole proportion. I know the Zoom Slider, but is there perhaps a more efficient way to "trim" the height of the columns that stand out?

[RafaelAri]

Thanks, It's a good idea

[Anonymous · Accepted solution]

Hi RafaelAri,

You can try logarithmic scaling.