Control the display of hidden worksheet data in a chart

Microsoft Office Excel 2003

Control the display of hidden worksheet data in a chart

  1. Click the chart.
  2. On the Tools menu, click Options, and then click the Chart tab.
  3. 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.