Use a stacked bar graph to make a tornado chart.
Make sure you have two columns of data set up for the tornado chart.
1. Well need one of the columns of data to be negative.
Type in -1 in any cell, Ctrl+C to copy it, then select one column of data and right-click the selection. Choose Paste Special from the menu.
2. Change the operation to Multiply and click OK.
3. To get a tornado-style look, select your data and go to the Data tab.
Click Sort and choose Largest to Smallest in the Order drop-down and hit OK.
4. Go to the Insert tab, open the Bar Graphs drop-down and choose the Stacked Bar Graph option.
5. You can also choose a more fitting style.
6. Double-click the top of the chart to open the right-side menu.
Choose the Format Axis button and open the Labels portion of the menu.
Choose Low as the Label Position.
7. The data on the left-side are still negative, click them to select them.
Open the Number portion of the menu, and change the Category to Custom.
Type in a new Format Code: ###0; ###0 and click Add.
This will change the numbers to show up as positive.
What do you use tornado charts for? Please let us know in comments
itech: Looks great, but what if I dont what my centre axis at 0? Is there anyway to have it at 100, say? and bars representing a change from that? Date: 2023-07-08
