Chart go blank after collapsing a grouped row

Hi,

I have a problem: whenever I collapse a grouped row in my worksheet, the chart, which the rows I collapsed were associated, will go blank.

I hope someone in the community can give light on this.

Thanks,

You have Plot visible cells only enabled.

Select chart and then
Chart Tools > Design > Select Data > Hidden and Empty Cells > Show data in hidden rows/columns

Thanks Andy. That was simple!