To visually contrast two series, you can use the Butterfly Chart. To do so, complete the following steps.
First, click empower Chart and select as a base Stacked Bars for a vertical Butterfly Chart.
Here, it is important that you enter negative values in the series that you want on the left to achieve the desired shape of the chart.
Then go to Labels, select the option Show Absolute Values and hide Show Column Sum.
Article is closed for comments.