Hidden source data

[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?

 

[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

 

[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