How To Draw Butterfly Chart In Excel

Tornado butterfly diagrams also called tornado plots or tornado charts are a special type of bar chart where the data categories are listed vertically instead of the standard horizontal.

How to draw butterfly chart in excel. For this simply multiply it with 1 check out this smart paste special trick i can bet you ll love it. Click for full featured 30 days free trial. Double click the chart title text at the top of the chart then delete the chart title text replace it with your own and click a blank space on the graph. Click on any part of the data 1 insert 2 and bar chart 3 then stacked bar 4.

On a mac you ll instead click the design tab click add chart element select chart title click a location and type in the graph s title. Due to its shape the chart resembles a butterfly and hence the name. To create a tornado chart in excel you need to follow the below steps. The xy chart labeler you need to restart your excel to activate this add ins.

The select data source window will open. First of all you need to convert data of store 1 into the negative value. As you can see in the screenshot below start date is already added under legend entries series and you need to add duration there as well. The xy chart labeler is a useful add ins to add move manage and delete the chart labels you can download here.

The insertion of a butterfly which is also known as tornado chart is going to be done in a simple step by step format without any complications. You can easily see how one series do compared to other series for a given data point in one glance. A butterfly chart is a chart where two entities are compared side by side using scales meeting at the center. Download and install the xy chart labeler.

These charts are sometimes also known as funnel or tornado charts though i find butterfly to be a better description as it allows for a greater variation in shape than a funnel or a tornado does. But first you need this kind of data. The charts tool in kutools for excel provides some usually used but difficult creating charts which only need to click click click a standard chart has been created. Add duration data to the chart.

Now you need to add one more series to your excel gantt chart to be. In this tutorial we will compare the sales performance of store a and store b. Butterfly chart is a very nice visualization technique for comparing two data series side by side. This will help you to show data bars in different directions.