This Excel tip, you must know! How to make a cyclone diagram?

When we encountered in the work of the analysis of the company personnel distribution, product advantages and disadvantages of the situation, the cyclone is the most commonly used a chart, you can let the boss at a glance to understand the company personnel status and product differences, so learn the production of Cyclone chart is very necessary, today's small series to share a whirlwind of production skills.

For example, make tabular data a whirlwind diagram.

Step one: Work with tabular data, where we add a column of auxiliary columns, and then use 0 minus the data to get negative numbers.

Second step: Select the appropriate data and insert a two-dimensional bar chart.

Step three: Set the data series format, where the series overlap is set to 100%.

Fourth step: In order to make the chart data according to the table data order, select the data content, right-click the format of the axis, check the reverse category, and then set the label position to "low."

Fifth step: Check the bar chart, right click to select Add Tag, then right click to select the Format tab, locate the number in the corresponding interface, and then enter the code "#;#;#" in the number format to click Add.

The values on the horizontal axis are processed in the same way, with the final change of the coordinate legend and the set caption.

：

The above is about the production of Cyclone Chart, we have any questions, welcome to leave a message below.

This Excel tip, you must know! How to make a cyclone diagram?