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.

We frequently use Excel sheets to analyze data, plan events, plan audits, produce charts, calculate the budget, plan expenditures, etc.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.