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](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/07/Show-hidden-data-on-chart-4.jpg)
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](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/07/Show-hidden-data-on-chart-2.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/07/Show-hidden-data-on-chart-3.jpg)
Now hidden data points also will be available on the chart.
![Hidden months are also available on the chart](https://www.pk-anexcelexpert.com/wp-content/uploads/2019/07/Show-hidden-data-on-chart-1.jpg)