O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required