pie chart missing column on subreport

[Ronze55]

Hi all

I am having trouble with the chart function on a subreport.

I inserted a chart object to a tabular report. the aim is to have a different pie chart displayed for each group.

I have four columns in my table stage1, stage2, stage3, stage4

my select statement is

select stagetime, sum(nValue) from table1 where group1 = reports!rptthis!group1;

amazingly the chart displays the information in the correct group. however, one of the stages is missing, stage4.

I double-clicked into the graph to get the datasheet view. i reordered the columns, i removed everything but stage4. but still can not get this stage up on the chart.

stage4 is displayed in the design view.

Any help on this is greatly appreciated.

thanks in advanced,
ronze