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

Data

Sources: langerresearch.com, Washington Post-ABC Poll (Reagan-Trump), Gallup polls (Eisenhower-Carter) | wapo.st/pollarchive

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Stacked Bar Chart example  Trump approval first 100 days - 31Stacked Bar Chart example  Trump approval first 100 days - 7