How to Make a COVID-19 Rose Chart?

What is the Rose Chart?

Have you ever seen this type of chart? Its name is Nightingale Rose Chart, also known as a Coxcomb Chart, Polar Area Diagram.

From Wikipedia

In the history, it is a chart invented by Nightingale when he submitted a report on soldiers’ injuries during the Crimean War.

The Nightingale Rose Chart is a histogram drawn in polar coordinates. The length of the arc is used to indicate the size (number) of the data.

Because the relationship between radius and area is a square relationship, it can exaggerate the proportion of the data, which is especially suitable for comparing values with similar sizes.

Due to the nature of the circle, it is also suitable for representing the concept of time within a cycle, such as a week and a month.

Application Scenarios for the Rose Chart

Suitable application scenarios：

– Compare the sizes of different categories

The following figure is a comparison of the usage of each browser. The following chart can clearly see the difference in the proportion of the use of Internet Explorer, Google Chrome and other browsers. The advantage of using a rose chart is that even if the data is similar, the difference can still be clearly seen.

Unsuitable application scenarios：

– Too few categories

The figure below shows the number of male and female students in a class. A pie chart is recommended for this scenario.

More charts in data visualization can be seen here.

Rose Chart Extension

Example 1: Fan rose chart

The fan-shaped Nightingale rose chart can be realized by setting the starting angle of polar coordinates, as shown below:





Example 2: Stacked rose chart

The principle of Nightingale’s rose chart is to draw the histogram in polar coordinates. If the histogram is extended to a stacked histogram, a stacked rose chart can also be realized.

The following rose chart shows the cumulative data for each year in Asia, Africa, America, and Europe. The final data and the proportion of each region can be displayed at the same time.

Comparison of the Rose Chart with Other Charts

With Histogram

Rose Chart is essentially a display of the histogram in polar coordinates.

The histogram uses the height of the rectangle to represent the size of the value.

Rose chart uses the radius of the fan to represent the magnitude of the value.

With Pie Chart

Rose Chart uses the radius of the fan to represent the size of the value, while the pie chart uses the radian of the fan to represent.

Rose chart can represent more classifications than the pie chart at the same time.

How to make a rose chart.

How to Make a COVID-19 Rose Chart?

Here I use FineReport as the data visualization tool, also you still have many other choices.

Prepare the Data

First, we need to get the latest COVID-19 data, WHO every day will update the situation report, you can find the data you want from the report.

This time we made a chart of the number of death cases, so we put the relevant data in the report into an excel file.

Just like this

Import the Data

FineReport supports many kinds of databases, including relational databases, text databases… It’s very convenient for us to make the chart cause it can connect the Excel file as a data source.

Then we open the FineReport designer, click the “+” button, choose the file as the data source.

Remember to put the Excel file in the “reportlets” folder, and you can find the Excel file in the “Selection”.

And also remember to click the “First row contains column headings”.

Design the Rose Chart

Click the insert from the menu bar, and choose float element->insert chart, and you can choose the chart you wanna make, here I choose the same radians chart.

Then we drag the data we just import to the cell, in this way, we can directly call the data. Remember to set the cell row height to 0 so that the data table is not displayed.

Associate Rose Chart with Data

Click data->, Associate data in A1 with data in B1, then all is finished! Click the preview, wow, you can’t believe that you have made it.

In order to make the data clearer, I chose relatively similar data. If you want to display data from all over the world, remember to scale the data to the logarithm, otherwise, too small data can hardly be displayed.

The following figure is a log of the world COVID-19 chart displayed after adjustment.

Summary

Through these various data visualization methods, we can more intuitively understand the changes of data in various places, and find some important points, such as the growth rate in Italy has exceeded China, so we need to be vigilant!

Finally, wish people can beat COVID-19 before July and restore peace to the world!

Follow FineReport Reporting Software to know more about the data visualization guides!

You might also be interested in…

How Can Beginners Design Cool Data Visualizations?

3 Types and 5 Management Dashboard Examples Sorted by Departments