Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.