info dissapears from graph when section of other sheet is in 'group'

Hi

i dont know if there is a way around this, i have a sheet, it has one large sheet with hundreds of rows under 3 headings, and i have a group on each of these so people can go in and expand their section and add details, i have a second sheet that contains some graphs simplifying the data collected in the 3 sections of the other sheet..

but i have just noticed when a section of the sheet is grouped its details are removed from the graph...

is there any way around this? i need the groups on as the sheet is so big and people do not want to be scrolling through other area's data when they can just expand their own...

Many Thanks
Neill

If you want the grouped data to remain visible in the charts then you need to unselect the Plot Visible Cells only option on each of the charts.

Select a chart
Tools > Options > Chart > Plot visible cells only

see "How to ..." menu at the top of the page