![xlstat add-in to excel xlstat add-in to excel](https://image.slidesharecdn.com/xlstat-staticticalsoftware-131011055050-phpapp02/95/xlstat-statistical-analysis-software-12-638.jpg)
This example shows you how to make the chart look like a butterfly chart. The excel tornado chart is also known as the Butterfly chart. Example #2 – Excel Tornado Chart (Butterfly Chart)
![xlstat add-in to excel xlstat add-in to excel](https://autocracking.com/wp-content/uploads/2020/01/Screenshot_2-300x169.png)
![xlstat add-in to excel xlstat add-in to excel](https://onthehub.com/wp-content/uploads/2018/03/2-xlstat-lg.jpg)
Select the Primary Axis and delete it.Select the “Inside Base” option to make the labels show up at the end of the bars and delete the gridlines of the chart by selecting the lines. Do right click on the Bars to add value labels by selecting the “Add data labels” option. Select the Label Position as “Low” from the drop-down option in the Labels section under Axis options.Select and do right-click to select the “Format Axis” option Now click on the axis showing the product name (A, B, C,…).Set the Axis bounds minimum with negative and maximum with positive values (same as above).Now select the primary axis and do right-click to select the “Format Axis” option.Also, check the box for “Values in Reverse Order” under Axis options in the Format Axis panel.Set the Axis Bounds minimum value under Axis options with the negative value of the maximum number (Both Maximum and Minimum bounds should be the same, but the minimum value should be negative and Maximum value should be positive).Select the Secondary Axis in the excel chart and do right-click to select the “Format Axis” option.
#Xlstat add in to excel series#
Select the “Secondary Axis” option in the Format Data series panel.