Sometimes we want to hide our data but still display the values in a chart. By defult Excel will remove the chart content when we hide rows or colunms.

The answer is to change a setting in the Excel Maze, sorry options box.

Select the chart you wish to change then goto: Tools > Options > ;Chart
then unselect the “Plot Visible Cells Only” option.

Another option to consider is putting the data in another worksheet then hiding that sheet.