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

This technique lets you build an Excel chart that shares supportive information in series form. Select the data labels and data. In this case, you’d select A1:D5.

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.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).