Graphs hiding when using Groups

[Ronny35]

Hi there

Hopefully this isn't a dumb question.

I have some graphs feeding off some data. In the data fields, I use groups to hide data, but can then click on the plus and unhide the data.

The problem is when I group some data and hide columns and if the graphs are using information that gets hidden, the graphs disappear.

Is there any way to stop this happening??

Thanks

 

[PaddyD]

select chart, go to tools | options | chart tab, deselect 'plot visible cells only'