Advice required - Creating graphs from hidden data

  • Thread starter Thread starter CRS
  • Start date Start date
C

CRS

I need to create some graphs from data that is derived from a long
series of separate calculations on my source data. For aesthetic
reasons, I would like to hide all the "interim" calculations on the
spreadsheet, but I've noticed that as soon as I hide the interim data
(i.e set the row height to zero), the detail on the graphs disappears.

I presume that this is a design feature feature of Excel (I supoose I
can just about accept the rationale for it), but does anyone know
whether there's a way around this?

Many thanks.

CRS.
 
1. Select the chart
2. Choose Tools>Options, Chart tab
3. Remove the check mark from 'Plot visible cells only'
4. Click OK
 
Many thanks Peo. Very impressed by the lateral thinking, and it's a tip
that I'll certainly be using.

Rgds.

CRS>
 
That's exactly what I wanted. Very many thanks Debra.

Best regards.

CRS.

________________________________________________________________________
Original message from Debra Dalgleish follows ...
 
Back
Top