Best visualisation/chart for tax related alternative scenarios

[Gregorian]

Hi Everyone,

I'm searching for some ideas and help in visualising alternative tax scenarios. I'm not doing a lot of charts in Excel so this is a bit hard for me to get the right chart.

The data contains two scenarios of allocating expenses between three accounts - actual method and 50-50 method. The aim is to show how the 50-50 method compares to the actual method in terms of tax saving or extra tax. Expenses are categorised in 7 categories, and some contribute to the tax payable and some don't, depending if there is a value in Account 2.

My first idea was to do a bar chart (not stacked) showing the categories and corresponding tax result produced by each category, but I did not manage to make anything visually appealing. And putting both the actual scenario and 50-50 scenario makes the graph even more cluttered.

Any help is appreciated.

Cheers,
Gregorian

[JeteMc]

Hello Gregorian and Welcome to Excel Forum.
"Best" is often subjective, so this is only my opinion: Clustered column charts are good for conveying comparisons in a way that is easy to understand.
I had to remove and then replace the Total row for both tables in order to get Total to appear on the chart.
Let us know if you have any questions.

[Gregorian]

Hi JeteMc,

This is great, thank you

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.