The OECD recently released a state of education report, which was referenced in the Forbes article, The Crazy Amount Americans Spend on Higher Education, In One Chart. The article showed a spending comparison per student by country and concluded that tuition is so high in the U.S. due to high per student spending.
Another dataset from the report showed higher education spending by funding source which I turned into a 100% horizontal bar chart. In several European countries, including Norway, Austria, Finland and Luxembourg, public money funds more than 90% of higher education costs. At the other end of the spectrum, public funds only cover 25% of the costs in the United Kingdom. Household contribution percentages were the highest in Chile, Japan, Australia, the UK and the US.
100% Horizontal Bar Chart
I used a horizontal bar chart because it’s easier to read the bar labels (country names) when you have many bars. It also makes it easy to see the mix differences when the data is sorted.
How I Created This 100% Horizontal Bar Chart
- First, I downloaded an Excel spreadsheet from the OECD and I deleted the data that I didn't need for the chart.
- I sorted the spreadsheet in descending order using the Public Sources column.
- Then, I copied the data and pasted it into the chart data sheet in PowerPoint. I selected the Switch Bars and Series icon (upper right corner of the data sheet) because the countries were shown as rows instead of columns.
- Under Bars and Series, I chose the colors for each of the series.
- To format the chart, I selected Chart from the ribbon. On the General tab, I unchecked the boxes under Show for bar labels and X axis. I selected the box for legend to add a legend to the chart. Then, I chose Hide All under the Labels heading.
- To format the legend, I clicked on it and chose a position of Upper Right. Then, I set the Legend Items Order as Series.
- Next, I selected Average Line from the ribbon to add it to the chart. In the Format Average line task pane, I added a title, chose the color to be the same as the Public Sources series and entered a manual value of 66%. This value was included in the dataset.
- To make the chart easier to read, I adjusted the left, right, top and bottom margins by dragging them.
Take this Chart and Make it Your Own
Download this 100% horizontal bar chart and edit it using Mekko Graphics. Here are some other charts that may be of interest to you.