Total of chart series

When creating a Stacked Bar or Stacked Column chart, this is a convenient way to show the proportion of a product or its categories sold over a given period of time. However, even if we choose to show values ​​on the series, it is not clear what the total sum is. Here’s a simple trick to create a chart that shows the share of each series in the sum, as well as the total sum of values.

Win-Loss chart

If you are engaged in budgeting and cost analysis it will be useful to know how to create a Win-Loss chart. This is a type of Bar Chart chart which, on the left side, holds negative values (most often the losses), and on the right side positive values (most often the gains). On the left side there can be also shown the costs, and on the right side the revenues. Let’s take a look at how this chart works!