The insertion of a butterfly graph, which is also known as a tornado chart, is going to be done in a simple step-by-step format without any complications.
But first, you need this kind of data:
How to create the Butterfly Chart?
Click on any part of the data (1), insert (2), and bar chart (3), then stacked bar (4).
Click on Design.
Click on Add chart element (1), Legends (2), and Top (3).
Right click on one of the series (1) and Select Data (2).
Click on the arrows to sort the series Padding South, South, Gap, North, and Padding North (1), and press ok (2).
Right-click on padding North (1), and click on no fill (2).
Click on no fill.
Note: You should repeat previous steps on Gap, and Padding north series.
Right-click on the gap (1). Add data labels twice (2 & 3).
Right-click on gap (1), and choose Format Data Labels (2).
Check category name (1), and uncheck values (2).
Right-click on the x axis (1), and choose format axis (2).
Click labels (1), and choose "None" in the labels position (2).
Click on the line, and press delete.
Click on Padding North, Gap, and Padding South, and then press delete.
Stretch the legends so both the south and North is showing on their sides.
In conclusion, you can keep working on the chart as you please.
You can download free Butterfly Chart template here.