How to show data of hidden rows/columns in Excel Charts - KING OF EXCEL

Tuesday, December 31, 2019

How to show data of hidden rows/columns in Excel Charts

How to show data of hidden rows/columns in Excel Charts

By default if you hide a certain row or column of a data on which a chart is based, Excel will automatically hide that data too. I must confess that I was quite annoyed when I wasn’t able to have a control over this behaviour as sometimes I do need to hide the data but still want data in the chart.
hide chart 1

But its easy to handle. To show the hidden data or data of hidden cells, rows or columns simply do this:
Have your chart active > Go to design tab > Click select data button in data group > A dialogue box will open > click Hidden and Empty cells > A dialogue box will pop up > check mark Show the data in hidden rows and columns > Click OK.
Now even if you hide the data, chart will still show the data plotted as normal.
hide chart 2
See! Told ya its easy!
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

Popular Posts