Carly Bond

Microsoft Excel – Showing hidden data in charts

Excel

Sometimes when you are producing reports in a chart form you don’t want to show the raw data behind it, however, if you hide your data from the end user, the chart information seems to disappear.

There is, however, an easy way to get around this…

1) Create your chart in the usual way but when you Select Data Source, Click the Hidden and Empty Cells button in the bottom left of the pop up box.

SelectDataSource

2) Select Show data in hidden rows and columns

3) Click OK