Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

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

Press "Ctrl" and "C" to copy the chart data. Even though you only selected one series, Excel will copy all of the chart data. Click anywhere on the second chart to select the chart.

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