Hidden source data

Z

Zadig Galbaras

Hi.

I wonder....
Why does my graphs go blank when I hide the cells containing the source
data?
Is there a way to omit this annoying occurrence?
 
K

Ken Johnson

Hi,

when you go Tools|Options|Charts is there a tick in the "Plot visible
cells only" box?

If there is then deselect that option.

Ken Johnson
 
Z

Zadig Galbaras

Thank you, Ken!

That did it!

I fumbled around a little until I found out that I had to mark an graph
prior to follow this procedure.

I'd say my spreadsheets looking much nicer when a lot of number collecting
cells are hidden
 
Top