The coronavirus pandemic led to a growth in remote work across most occupations. The largest growth was in software and IT services and in wellness and fitness jobs. Education was the only sector that saw a small decrease. Data are from a LinkedIn survey of work in Canada.
Remote Work Growth in a Horizontal Cluster Bar Chart with Bar Comparison Lines
Why Use a Horizontal Cluster Bar Chart with Bar Comparison Lines for Remote Work Growth
The cluster bar chart allows me to show the change in remote work across two time periods for each occupation. The bar comparison lines call out each change. As an alternative, you could put the changes in a data column. I made the chart horizontal to make it easier to read each occupation name. You can try the chart vertically and make each bar label slanted. This type of chart works well for up to about 15 cluster bars.
How I Made this Remote Work Horizontal Cluster Bar Chart
Here is the data I used to create the chart:
Here's how I made the highest paid athletes horizontal bar chart with data column:
- copy the data from LinkedIn into Excel
- create a horizontal cluster bar chart in PowerPoint from the Excel data
- use Switch Bars/Series to treat the rows as bars and the columns as segments (clusters)
- hide the y axis and adjust internal margins and bar gaps
- add the bar comparison lines in each cluster bar
- format segment values and bar comparison values with % as suffix and 1 decimal place
- add legend and move inside chart area
Take This Chart and Make It Your Own