A question that has come up a few times during various training sessions on charts and dashboards is “Can I hide one or more of the items in a data table attached to a chart?”

A Data Table is displayed inside the chart area underneath the chart and contains a copy of data used to create the chart. The question relates to how to hide a row in the data table but keep it visible in the chart.

To answer the question…yes you can and this video explains how to do it.

Links to the video and individual sections below…


What is a Data Table?

Add a Data Table to a Chart

Format Cells to Hide the Cell Contents

Data Table – Hide Legends and Borders

Show Data from Hidden Cells