Created attachment 168521 [details] Attachment contains spreadsheet and examples when rows expanded or collapsed Grouped rows in a spreadsheet are not shown in a chart if that group is collapsed. This behavior was seen in versions 6.4.7 and 7.0.4. I don't know if it was seen in earlier versions.
The data series property has the option "Include values from hidden cells". Use that to show the hidden series too. The option affects all series, although set in the properties of a single series.
Thank you.