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
Data
| President | Approve | Disapprove |
|---|---|---|
| Trump | 42% | 53% |
| Obama | 69% | 26% |
| Bush 43 | 63% | 32% |
| Clinton | 59% | 39% |
| Bush 41 | 71% | 22% |
| Reagan | 73% | 19% |
| Carter | 63% | 18% |
| Ford | 48% | 32% |
| Nixon | 61% | 12% |
| Johnson | 77% | 9% |
| Kennedy | 78% | 6% |
| Eisenhower | 73% | 10% |
| Truman | 87% | 3% |
Sources: langerresearch.com , Washington Post-ABC Poll (Reagan-Trump), Gallup polls (Eisenhower-Carter) | wapo.st/pollarchive
