• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Basic Charting Techniques > Plotting Hidden Cells

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.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint