I first saw a link to this chart on Politico. The original chart is a clustered column chart, but I though it would be interesting to show the data in a stacked bar chart instead. Stacked bar charts make it a lot easier to compare bar lengths. Here's the original:
One thing to note is the approval and disapproval ratings don't add up to 100%. This is due to some survey respondents expressing no opinion. I played with plotting "no opinion" as a another data series in the chart, but decided to leave it out to keep things simple.
Update: The Washington Post now has a full page of fancy poll result charts.
Steps to create
- Add the data to a worksheet
- Select the data
- Insert > Recommended Charts > Stacked Bar Chart
- Delete vertical gridlines
- Move legend to top
- Add title and increase font size
- Add data labels