Drawing a Tornado Chart in Excel

Buzz

The following article provides a detailed guide on how to draw a tornado chart in Excel.

Step 1: Draw the initial chart in a horizontal layout:

Step 2: Select the Male parameter -> Right-click and choose Format Data Series to customize the format for male data.

Step 3: The Format Data Series dialog box appears in the Series options section, select Secondary Axis.

After selecting Secondary Axis, the chart takes the following shape:

Step 4: Select the X-axis (horizontal axis showing the proportion values) -> Right-click and choose

Format Axis.

Step 5: The dialog box appears in the Bounds section under:

- Minimum: Input -100.

- Maximum: Input 100.

- Major: Input 25.

- Minor: Set to Auto mode.

After selecting, the chart takes the following shape:

Step 6: Continue selecting the upper horizontal axis -> right-click and choose Format Axis.

Step 7: In the Bounds section, enter the parameters as shown in the diagram:

Move the mouse pointer downwards and check the box next to Values in reverse order.

After selecting, the chart appears as follows:

Step 8: Next, format to remove negative values on the X-axis. Right-click on the X-axis (one of the two axes) -> Select Format Axis.

Step 9: In the Number section under Category, choose Custom; in the Format Code section, enter 0; 0 -> click Add. In this example, there are no units, but if you have percentages, enter 0%;0%.

After selecting, the X-axis no longer has negative values. So, the tornado chart looks like this: Values of the same type are grouped on one side of the graph. By looking at the chart, you can immediately compare the gender ratios between blocks.

In all grade levels, the proportion of female students exceeds that of male students, with Grade 1 having the highest proportion of female students.

Above is a detailed guide on how to draw a tornado chart. Hope it helps you apply it to compare data visually and quickly.

Wishing you all success!

Frequently Asked Questions

What are the first steps to draw a tornado chart in Excel?

To start drawing a tornado chart in Excel, you need to first create an initial chart in a horizontal layout. This sets the foundation for the following steps where you will customize the data series and format the axes.

How can I customize the Male parameter in the tornado chart?

To customize the Male parameter, right-click on it within the chart and select 'Format Data Series'. This action allows you to open the Format Data Series dialog box, where you can adjust settings such as selecting the Secondary Axis to display the data effectively.

What values should I input in the Bounds section for the X-axis?

For the X-axis, you should input the following values in the Bounds section: Minimum as -100, Maximum as 100, Major as 25, and set Minor to Auto mode. This will help in appropriately scaling the axis for better visual representation of data.

Is it possible to remove negative values from the X-axis in Excel?

Yes, it is possible to remove negative values from the X-axis. Right-click on the X-axis, select 'Format Axis', and in the Number section, choose 'Custom'. Enter '0;0' in the Format Code section, and click 'Add' to eliminate negative values from the chart.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]