Horizontal bar chart of covid deaths in long-term care as a percentage of total covid deaths by state

US COVID Deaths in Long-Term Care

For most states, the majority of Covid-19 deaths were in long-term care facilities, as shown in this horizontal bar chart. For the country as a whole, 42% of all Covid-19 deaths were in long-term care facilities. Minnesota's 635 Covid deaths in long-term care were 81% of the state's total Covid deaths.  Rhode Island, New Hampshire and Connecticut all had 70% or more of their Covid deaths among long-term care facility occupants.  At the other extreme, only 20%  of New York's Covid deaths and 24% of Nevada's were long-term care related. Even though New York's percentage was lowest, it had the greatest number of deaths in long-term care at 5,847. Data were compiled by the Kaiser Family Foundation and came from 37 states as of May 21, 2020.

COVID Deaths at Long-Term Care Facilities in a Horizontal Bar Chart with Data Column and Average Line

Horizontal bar chart of covid deaths in long-term care as a percentage of total covid deaths by state

How I Made this Horizontal Bar Chart with Data Column and Average Line

Here is the long-term care data I used to create the horizontal bar chart:

Horizontal bar chart of covid deaths in long-term care as a percentage of total covid deaths by state

Here's how I made the chart:

  • start with the Excel download of the KFF data
  • create a Mekko Graphics horizontal bar chart in PowerPoint based on the Excel data
  • use Switch Bars and Series to treat rows as bars
  • remove extraneous columns from the Mekko Graphics Data Editor
  • treat column B as a data column
  • adjust internal margins, bar gaps and y axis scale to maximize chart's horizontal area
  • shrink chart fonts to 9 point
  • add average line and set to 42%
  • insert y axis title and hide other y axis elements and x axis line
  • edit data column header to fit on 2 lines
  • change series color to grey and segment color for New York to red
  • bold data column entry for New York
  • format bar totals to display as percentage

Take This Chart and Make It Your Own

Download this chart and edit it using Mekko Graphics. See more bar charts in our chart gallery. Here are some other charts that may be of interest: