How To Use Clustered Bar to Create Tornado Chart

Yesterday, I post how to use Conditional Formatting to create Tornado Chart, today, I'll show you how to use Clustered Bar to create . Here is our final Tornado Chart:
Use Clustered Bar to Create Tornado Chart

OK, let’s jump straight into creating a Tornado Chart.

Getting the data

In this tutorial, we will compare the sales performance of Store A and Store B. You can copy A1:C10 to a new worksheet to start this tutorial.

1
2
3
4
5
6
7
8
9
10
A B C
Products Store A Store B
Product 1 308 245
Product 2 454 428
Product 3 550 513
Product 4 602 547
Product 5 632 677
Product 6 754 692
Product 7 823 836
Product 8 890 845
Product 9 907 857

Use Clustered Bar to Create Tornado Chart

  1. Select A1:C10.
  2. Under the Insert menu tab, in the Charts group, click the Bar button and choose Clustered Bar in 2-D Bar.
    Clustered Bar
  3. In Chart Area, Right click any of the Series "Store B" (Red Bar), choose Format Data Series in the quick menu.
    Format Data Series
  4. In the Format Data Series window, under Plot Series On, select Secondary Axis, then click Close.
    Secondary Axis
  5. In Chart Area, Right click Secondary Horizontal (Value) Axis (in the top of chart), choose Format Axis.
    Format Secondary Axis
  6. In Format Axis window, under Axis Options, Minimum: Fixed, -1000, Maximum: Fixed, 1000, and click Values in reverse order, then click Close.
    Secondary Axis Options
  7. In Chart Area, Right click Horizontal (Value) Axis (in the bottom of chart), choose Format Axis. Or press CTRL+1.
    Primary Horizontal Axis
  8. In Format Axis window, under Axis Options, Minimum: Fixed, -1000, Maximum: Fixed, 1000, then click Close.
    Primary Horizontal Axis Options
  9. In Chart Area, Right click Vertical (Category) Axis, choose Format Axis. Or press CTRL+1.
    Format Vertical Axis
  10. In Format Axis window, under Axis Options, follow below settings: Major tick mark type: None, Axis labels: Low, then click Close.
    Format Vertical Axis Options
  11. In Chart Area, Right click Series "Store B", choose Add Data Labels.
    Series Store B Add Data Labels
  12. In Chart Area, Right click Series "Store A", choose Add Data Labels.
    Series Store A Add Data Labels
  13. In Chart Area, select Secondary Horizontal (Value) Axis, press Delete, select Horizontal (Value) Axis, press Delete, select Horizontal (Value) Axis Major Gridlines, press Delete. Add chart Title, named with "Tornado Chart" or what you like.

Video

How To Use Clustered Bar to Create Tornado Chart

Leave a Reply

Your email address will not be published. Required fields are marked *