display hidden data on the chart
Excel Tips and Tricks

Show Hidden/Collapsed Cells data on the Chart

In this article, you will learn how to display hidden data on the chart. if we create a chart for month wise sales and hide or collapse few months then those months data will not be visible on the chart.

March to July data is not visible
March to July data is not visible

If you want to display the hidden data on the then below are the steps-

  • Right click on the chart and click on Select Data.
  • Select Data Source window will be opened.
  • Click on Hidden and Empty Cells button.
Select Data Source window
Select Data Source window

 

  • Hidden and Empty Cells Setting window will be opened.
  • Tick the Show data in hidden rows and columns box.
  • Click on OK.
Hidden and Empty Cells Setting window
Hidden and Empty Cells Setting window

 

Now hidden data points also will be available on the chart.

Hidden months are also available on the chart
Hidden months are also available on the chart

 

Click here to download the Practice file-

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com