Excel chart question: is there an easy way to make a trend line fatter to reflect a range of data?

Factual Questions
1

Picture this: I’d like to plot the trendline of (say) an election poll result over time. Aside from that one narrow line, I’d also like to plot a fat line in the background that shows how the range of the margin of error fluctuates over time, so I can point to instances where the thin line breaks out of the fat line’s range.

There are ways I can jury rig a solution, but they’re all frankly a PITA to work around. Is there a simple way, preferably in Excel?

Taking some inspiration from Edward Tufte’s favorite chart, if it means anything to you . . .

2

It looks like ggplot2’s ribbon plots will do exactly what you want. Excel really shouldn’t be considered statistical software at all given the alternatives that are out there.

ETA: There’s a better example about halfway down this page.

3

One way to do this in Excel comes to mind. Try using two area charts, with one chart covering the top end of the range, and another (with color matching the picture’s background) for the lower end of the range. That should work.

5

Repoated.