Including Hidden Table Data in a Chart
If you’ve hidden rows or columns in a table, but want to include or exclude them from
a chart, you can elect to do so in the Chart pane of the Chart inspector.
To include or exclude hidden data:
Select the chart, and then click the Inspector button in the toolbar.
Click the Chart button in the Inspector window, click Chart, and then do one of
To include hidden data in your chart, select Show Hidden Data.
To exclude hidden data from your chart, deselect Show Hidden Data.