Show chart data in hidden cells

Excel 365
When you have some hidden cells in your chart data, Excel ignores data for these gaps and doesn't show the corresponding chart elements.

For example, there is some hidden data in the table:

Chart with hidden data in Excel 2016

If you want to see hidden data in the chart, do the following:

   1.   Select the chart data by doing one of the following:

  • Under Chart Tools, on the Design tab, in the Data group, choose Select Data:
    Select Data in Excel 2016
  • Right-click in the chart area and choose Select Data... in the popup menu:
    Select Data in popup menu Excel 2016

   2.   On the Select Data Source dialog box, click the Hidden and Empty Cells button:

Select Data Source in Excel 2016

   3.   On the Hidden and Empty Cell Settings dialog box, check the Show data in hidden rows and columns checkbox:

Hidden and Empty Cell Settings in Excel 2016

Excel will show all hidden data on your chart:

Show hidden data in the chart in Excel 2016

See also this tip in French: Afficher les données du graphique dans les cellules masquées.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.