Plotting Hidden Cells

Excel normally ignores any hidden rows or columns in a chart's data range. If you want hidden cells to be plotted, create the chart in the normal way. Select any element of the chart, choose Tools, Options, go to the Chart tab, and then clear the Plot Visible Cells Only check box.

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.