Categories
The current global pandemic has caused socioeconomic devastation worldwide.
And it is for this reason, healthcare facilities, pharmaceutical corporations, governments, and World Health Organization (WHO) are tracking the Covid-19 spread closely. The amount of data generated as a result of close surveillance is immense.
Insights into the data have helped immensely in informing mitigation strategies.
In the last few months, the spread of the disease is gone down significantly. And this is partly due to the WHO leveraging data and sharing insights openly with governments, research centers, and healthcare facilities.
Some of the charts that the World Health Organization (WHO) used to communicate its data stories successfully include:
Excel is one of the go-to popular data visualization tools among professionals and business owners worldwide.
But the visualization tool has very basic Sentiment Trend, Double Bar, Grouped Column, and Dual Axis Line charts. And this implies you’ve got to invest extra effort and time to edit the charts to align with your needs.
There’s a specific add-in you can download and install in your Excel to access Pandemic Comparison Chart.
In this blog post, you’ll learn the following:
Before addressing the how-to, we’ll cover the following: the best graphs for tracking the Coronavirus Pandemic.
Suppose you have a Corona vaccination data center.
Your goal is to get insights into the number of females and males who received the vaccination. Assume the table below represents the data in your possession.
Can you provide a coherent data story by just looking at the numbers below?
| Age Group | Male | Female |
| 18 to 24 | 1,054 | 1,111 |
| 25 to 29 | 1,057 | 1,641 |
| 30 to 34 | 1,470 | 2,526 |
| 35 to 39 | 1,793 | 3,549 |
| 40 to 44 | 2,534 | 5,470 |
| 45 to 49 | 4,842 | 9,587 |
| 50 to 54 | 8,692 | 13,514 |
| 55 to 59 | 13,855 | 15,088 |
| 60 to 64 | 19,897 | 17,718 |
| 65 to 69 | 30,179 | 23,745 |
| 70 to 74 | 31,688 | 22,873 |
| 75 to 79 | 28,753 | 21,490 |
| 80 to 84 | 21,779 | 19,052 |
| 85 to 89 | 13,104 | 13,662 |
| 90+ | 5,645 | 8,066 |
Note the difference after visualizing the data above.
A Sentiment Trend Graph is one of the best Pandemic Charts for demonstrating the trend of sentiments. The chart is amazingly critical, especially if your goal is to show the growth and decline of key variables.
The line curve in the chart shows the overall pattern and trend of a key variable over a specified period.
Take a look at the table below? What’s going on?
| Countries | Total Infections | Recoveries |
| USA | 81,410,101 | 77 |
| India | 43,009,390 | 99 |
| Brazil | 29,630,484 | 95 |
| France | 24,137,160 | 93 |
| UK | 20,093,762 | 92 |
| Germany | 18,683,287 | 79 |
| Russia | 17,582,692 | 92 |
| Turkey | 14,693,917 | 97 |
| Italy | 13,861,743 | 90 |
| Spain | 11,324,637 | 93 |
Notice the difference after visualizing data using Double Bar Chart
As the name suggests, the chart is made up of bars with varying axes.
Use the visualization design if your goal is to display insights into two varying metrics for in-depth insights. The role of line curves is to depict your data’s overall patterns and trends.
As you can see (in the table below), it’s not easy to tell a coherent data story. You’ve got to visualize the data to display insights.
| Countries | Delivered | Earmarked, but not delivered | Outstanding Commitment |
| United States | 272,000,000 | 276,000,000 | 552,000,000 |
| China | 89,000,000 | 23,000,000 | 738,000,000 |
| Germany | 24,000,000 | 86,000,000 | 65,000,000 |
| France | 22,000,000 | 42,000,000 | 56,000,000 |
| United Kingdom | 15,000,000 | 7,000,000 | 78,000,000 |
Notice the difference after visualizing the data above. You can easily point out key metrics, such as the outstanding commitment and delivered vaccine doses.
A Grouped Column Graph (one of the recommended Pandemic Comparison Charts) displays more than one data series in clustered vertical columns. Each data series shares the same axis labels, so vertical bars are grouped by category.
Clustered bars directly compare multiple series in a given category. The chart is amazingly easy to read and interpret, even for a non-technical audience.
Adding another variable to a chart can double the amount of data that is represented. Besides, the spacing between grouped bars makes comparisons clearer.
The Grouped Column Chart emphasizes the data within categories more than the data between them.
However, you can make comparisons between categories more clearly by using consistent color schemes.
Use a Dual Axis Line Graph (one of the best Pandemic Comparison Charts) if your goal is to display insights into varying metrics.
The visualization design uses two different axes to illustrate the relationships between two variables.
All the key data points are connected by a straight line to depict the overall pattern and trend. Keep reading because we’ll address the following in the coming section: what is the trend of Covid-19 based on a graph?
One of the tested and proven charts for displaying trends of key metrics related to the Covid-19 pandemic is a Dual Axis Line Chart. The visualization design is incredibly easy to read and interpret.
Excel generates very basic Dual Axis Line Graph and other Pandemic Comparison Charts. And this means you’ve got to spend extra effort and time editing the chart.
You don’t have to undergo all this.
Download and install a particular third-party add-in into your Excel to access ready-made Pandemic Comparison Charts.
There are thousands of add-ins purposely designed for Excel. To simplify things, we tested over 60 data visualization-based add-ins.
We narrowed down our results based on the following factors:
The Excel add-in that met all our conditions is ChartExpo.
The tool comes with ready-made Pandemic Comparison Charts that need minimum editing.
Let’s take a closer look at ChartExpo.
ChartExpo is an Excel-based add-in with an ultra-friendly user interface to ensure that any professional can visualize data, irrespective of their coding or programming skills.
Keep reading because we’ll address the following in the coming section: what is the trend of Covid-19 based on a graph?
| Dates | Cases | Deaths |
| Jan-20 | 0 | 0 |
| Feb-20 | 0 | 0 |
| Mar-20 | 5476 | 2541 |
| Apr-20 | 5647 | 2341 |
| May-20 | 6123 | 1347 |
| Jun-20 | 6574 | 1147 |
| Jul-20 | 6134 | 1347 |
| Aug-20 | 7432 | 1437 |
| Sep-20 | 24650 | 1234 |
| Oct-20 | 44730 | 954 |
| Nov-20 | 93247 | 756 |
| Dec-20 | 167532 | 1524 |
| Jan-21 | 214000 | 3749 |
| Feb-21 | 168734 | 4378 |
| Mar-21 | 98573 | 3876 |
| Apr-21 | 45732 | 2876 |
| May-21 | 51269 | 2678 |
| Jun-21 | 27589 | 2167 |
| Jul-21 | 6547 | 1534 |
| Aug-21 | 912 | 1274 |
| Sep-21 | 5498 | 1673 |
| Oct-21 | 37951 | 4237 |
| Nov-21 | 29574 | 3124 |
| Dec-21 | 597413 | 3134 |
| Jan-22 | 1050000 | 3473 |
Check out the benefits of using Pandemic Comparison Charts below:
Simplifying patient care data through data visualization helps healthcare workers, such as nurses, interpret data faster.
You can use Pandemic Comparison Charts, such as the Dual Axis Line Chart, to illustrate an individual’s health status compared with others in a similar demographic.
The media often use charts to depict pandemic-related trends on a large scale. For instance, confirmed COVID-19 cases in the U.S. by state.
The Pandemic Comparison Charts, such as Double Bar Charts, can illustrate the most and least affected states.
Some of the tested and proven Pandemic Comparison Charts include:
These charts are incredibly easy to read and interpret, even for non-technical audiences. And this explains why media houses use these charts to communicate pandemic-related stories for more charts you can explore ChartExpo library in detail.
The ongoing global pandemic has caused socioeconomic devastation across the world.
And it is for this reason, healthcare facilities, pharmaceutical companies, and World Health Organization (WHO) are tracking the Covid-19 spread closely. The amount of data generated as a result of close surveillance is immense.
Insights into the data have helped immensely in informing mitigation strategies. In the last few months, the spread of the disease is gone down significantly. And this is partly due to WHO leveraging data and sharing insights openly with governments, research centers, and healthcare facilities.
Some of the charts the World Health Organization (WHO) used to communicate its data stories successfully include:
Excel is one of the go-to popular data visualization tools among professionals and business owners worldwide. But the visualization tool lacks ready-made and visually stunning Pandemic Comparison Charts.
So, what’s the solution?
We recommend installing third-party apps, such as ChartExpo, into your Excel to access ready-made Pandemic Comparison Charts.
ChartExpo is an add-in you can easily download and install in your Excel app. Besides, this tool comes loaded with insightful and easy to interpret charts.
You don’t need programming or coding skills to visualize your data using ChartExpo.
Sign up for a 7-day free trial today to access easy-to-interpret and visually appealing Pandemic Comparison Charts.
How much did you enjoy this article?
We will help your ad reach the right person, at the right time
Actionable insights discovered for you. Now you can do more in less time.
PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.
Frequent audits will help you optimize your PPC campaign for success.
Visualizations give you the ability to instantly grasp the insights hidden in your numbers.
Experience the new revolution in reporting … click your way to insights, don’t scroll.
Calculate the number of combinations in your PPC campaign. It may surprise you.
Related articles
Click to learn how to plot a Stacked Area Chart in Excel. You’ll also learn how to read a Stacked Area Chart.
Click to learn the top 5 Google Sheets Charts for your data stories. Also, we’ll address the following question: what are Google Sheets Charts.
Click to learn about business intelligence vs. data analytics differences. We’ll also address the following question: what is business intelligence?
