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 Chart the Frequency of a Data Set on Excel. ... a teacher might wish to calculate and display her students' grades by tabulating the number of scores corresponding to each letter grade.