Adjusting axis for stacked column charts

[swong1709]

Hi All

I have some sample data and was looking to plot a stacked column chart.
However is it possible for the axis to show the net total? For 2020, the top of the column is 120, but was hoping to show 90.

Alternatively, is there another graph to better show this data. I am trying to compare the number of sales in different regions and you can assume D are the refunds.

Sorry, can't find the GO ADVANCED button to attach the file...

Many thanks


Stacked Chart.PNG

[swong1709]

Have attached the file now

[Andy Pope]

You would need to deduct the refund amount (D) from the other categories (A/B/C).
How much you should deduct from each amount is dependent upon whether you know exactly where the refunds should be allocated.
If not you can either take the same value from each or a proportion

[swong1709]

Many thanks for the quick reply!

I was also considering deleting the axis labels and just show each category with data labels - so that I can keep the original values