Home > Topics > excel > body text

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

WBOY
Release: 2022-06-14 11:29:13
forward
2628 people have browsed it

This article brings you relevant knowledge about excel, which mainly introduces related issues about how to use conditional formatting to create whirlwind charts, paired bar charts, also called whirlwind charts. The characteristic is that two sets of data bars are stretched in the left and right directions along the middle vertical axis. Let's take a look at it together. I hope it will be helpful to everyone.

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

Related learning recommendations: excel tutorial

Speaking of the 2021 Tokyo Olympics, the Chinese men’s football team defeated the German team 5:0. The statistics of each project are as follows:

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

In order to make these data more intuitive, we can change it to the following:

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

Achieving such an effect in Excel is actually not complicated. Next, Lao Zhu will talk about the specific steps with you:

Step 1:

First adjust the data structure and The project is placed between the two teams.

Then adjust the column width to 20, and set the cell alignment to left and right respectively.

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

Step 2:

Select the leftmost data range J2:J11 and set conditional formatting.

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

Step 3:

Select the rightmost data range L2:L11 and set conditional formatting.

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

Step 4:

Set cell format.

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

Continue to beautify:

Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel

After simple processing, it will look taller immediately, okay?

This type of paired bar chart, also called a cyclone chart, is characterized by two sets of data bars extending in the left and right directions along the middle vertical axis. It is often used to compare the data of two types of things in different projects, such as the proportion of support and opposition of different think tanks for a certain project, the comparison of various technical indicators before and after the transformation of a certain equipment, etc.

Related learning recommendations: excel tutorial

The above is the detailed content of Example Analysis: How to use conditional formatting to create a whirlwind chart in Excel. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:excelhome.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template