Control the display of hidden worksheet data in a chart
- Click the chart.
- On the Tools menu, click Options, and then click the Chart tab.
- Do one of the following:
- To show all worksheet data in the chart, even if some rows or columns are hidden, clear the Plot visible cells only check box.
- To prevent hidden rows or columns from displaying in the chart, select the Plot visible cells only check box.