This chart is an excellent visual tool that gives a quick idea of the balance sheet structure across several years.

Unlike stacked column charts typically used for such type of graphs, this chart shows current and long-term assets and liabilities clustered on the horizontal axis. Positioning them on the same line makes them easier to compare between each other within the same year (e.g. current assets against long-term assets) and over time (every category).

To illustrate the share of each section in the total asset and liability plus equity amounts the chart has columns showing those total values.

All components of the chart are native Excel chart elements and are updated automatically as you change the source data, without any manual interventions. It is compatible with all versions of Excel and does not use VBA macros.

The chart delivers the message in an efficient and intuitive way and has a fancy design. It will help you make your presentations and reports look more professional and will impress your managers, clients, colleagues and other important ones.

The chart is flexible to change and can be adjusted to your specific requirements if needed. Let me know if you need any help changing the format or content of it.

You must log in to submit a review.