How to show stacked column with different size data

Hi, I'm trying to create a stacked column graph with data that ranges from 0.2 to 900. Visually the smaller data figures like 0.2 comes out too small and smushed, I'd like to make it show as a thicker bar, how can I do this? I tried playing around with the Format Axis to change the major/minor units, but that doesn't seem to work. Can someone help? Below is the data.

Thanks!

A Comp B Comp C Comp E Comp F Comp Total
2012 2 2
2013 5 0.8 6
2014 5 0.3 5
2015 5 0.2 0.3 6
2016 5 0.4 5
2017 5 100 0.5 106
2018 600 600
2019 -
2020 900 900
Total 627 900 100 1 1 1,630

Here's the model, I tried the logarithmic scale but then the larger numbers disappear?

Book12.zip

If I create another table that is rescaled, is there a way to have the chart pick up 1 table for the columns, and another table for the data labels? Or do I have to create the chart with the rescaled table and manually overwrite the data labels?

OK thanks for your help, if I can link them then it shouldn't be a problem.

Thanks!