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.

Using Excel’s Data Model feature, we’ll display the description field instead of the shelf code when grouping and analyzing the values without using VLOOKUP() or any other functions.

As you add data to each cell, the chart updates to display the new data. Even better, Tables bring the useful magic of Filters to your charts. Suppose you have a table with monthly budget figures ...