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.

How to Remove an Embedded Chart in Excel. Microsoft Excel can add charts to your workbook in two forms - chart sheets and embedded charts. Chart sheets set charts as new sheets within the workbook.