Fan Chart

Apply light shading above and below your line to indicate margins of error.

You can shade +/- a standard deviation, a confidence interval, and more.

Examples

More Charts

Ann K. Emery shares 40 tips in 40 days to celebrate Excel's 40th birthday. HBDXL

Happy Birthday, Excel!

Fewer Colors & Report Templates by Emma Williams

Ann K. Emery from Depict Data Studio is a data visualization expert, offering private workshops, online courses, and consulting.

Splitting with =TEXTBEFORE and =TEXTAFTER in Excel