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.
Inside Out: Don't hold down Ctrl
If you select the chart object rather than an element of the chart, the Plot Visible Cells Only check box is unavailable. If you see clear (white) handles around the perimeter of the chart, you've selected an embedded chart object. Be sure you're not holding down Ctrl, and then select again.
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
