“Split-Plus-Total” Chart
Originally published: 10/07/2025 09:33
Publication number: ELQ-42421-1
View all versions & Certificate
certified

“Split-Plus-Total” Chart

A convenient chart illustrating periodic values and their breakdowns

Description
This chart is an excellent visual tool showing, for example, total sales revenues or units sold by year broken down into products, geographies, regions and so on.
Unlike stacked column charts typically used for that, this chart shows the elements clustered on 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 element in the total 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.
In addition to visualizing sale results, you can find other uses of this chart as well. It 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.

This Best Practice includes
1 Excel file

Acquire business license for $9.00

Add to cart

Add to bookmarks

Discuss

Further information

Analysis of revenues and sales volumes

To analyse revenues and/or sales volumes (structure and changes) over time


0.0 / 5 (0 votes)

please wait...