How to draw tornado charts in Excel
The following article details how to draw tornado charts in excel.
Step 1: Draw the original chart in a horizontal format:
How to draw tornado charts in Excel Picture 1
Step 2: Click the Male parameter -> Right-click and choose Format Data Series to select the format for the male ratio data.
How to draw tornado charts in Excel Picture 2
Step 3: The Format Data Series dialog box appears in the Series options section, select Secondary Axis .
How to draw tornado charts in Excel Picture 3
After selecting the Secondary Axis chart, the shape is as follows :
How to draw tornado charts in Excel Picture 4
Step 4: Select the X axis (horizontal axis represents the values of the scale) -> Right-click and choose Format Axis .
How to draw tornado charts in Excel Picture 5
Step 5: The dialog box appears in the Bounds section of the item:
- Minimum : Enter -100.
- Maximum : Enter 100.
- Major : Enter 25.
- Minor : Leave the Auto mode .
How to draw tornado charts in Excel Picture 6
Once the selection is made, the chart will look like:
How to draw tornado charts in Excel Picture 7
Step 6: Continue to select the upper horizontal axis -> right click and choose Format Axis .
How to draw tornado charts in Excel Picture 8
Step 7: In Bounds, enter parameters as shown:
How to draw tornado charts in Excel Picture 9
Move your mouse down to the bottom of the check box to select the Values in reverse order section .
How to draw tornado charts in Excel Picture 10
The result after choosing the chart has the form:
How to draw tornado charts in Excel Picture 11
Step 8: Next, format the negative values in the X axis. Right-click the X axis (1 of the 2 axes) -> Select Format Axis .
How to draw tornado charts in Excel Picture 12
Step 9: In the Number section, select Category section, select Custom , Format Code section enter 0; 0 -> click Add . In this example, there is no unit, if in the case you leave unit% enter 0%; 0%.
How to draw tornado charts in Excel Picture 13
After the selection of the X-axis is no longer a negative value. So, the tornado chart has the form: The values of the same type are on the same side of the graph. Looking at the chart, you can immediately compare the sex ratio among the blocks.
How to draw tornado charts in Excel Picture 14
Among all blocks, the percentage of female students is higher than that of male students, and grade 1 has the highest percentage of female students.
Above is a detailed guide on how to draw a tornado chart. Hope to help you with the application to compare data visually and quickly.
Good luck!
You should read it
- How to draw a map chart on Excel
- How to draw a pie chart in Excel 2016
- How to create 2 Excel charts on the same image
- How to draw charts in Excel
- How to draw flow charts in Excel
- Instructions on how to create charts in Excel professional
- How to draw a bar chart in Excel
- Instructions on how to copy charts from Excel to Word
- How to Use Charts and Diagrams in OpenOffice Draw
- How to rename data series in Excel chart
- Steps to use Pareto chart in Excel
- How to create charts in excel 2007 is extremely simple!
May be interested
CHOOSE function combines SUM - Conditional sum in Excel
SUMSQ, SUMXMY2, SUMX2MY2, SUMXPY2 functions - Sum function contains squared values in Excel
ROUND, ROUNDDOWN, ROUNDUP functions - Functions for rounding decimal numbers in Excel
SLN function - Returns the depreciation value of an asset using the straight-line method in Excel
DDB function - Calculate depreciation of assets in Excel
MINVERSE function - The function returns the inverse matrix of a given matrix in Excel