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.

Type your data or use existing data from your file. Highlight the range of cells containing your data. Then click the Insert tab and click the Insert Column or Bar Chart button. Click the ...