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.