Excel Chart Problem.

[Ryath]

Hi all,

At the moment i have a crosstab query which returns a result table looking like this:-

Aircraft Model BNG BRF CC CF CIR CPF
A330 1 5 1
A340 1 1 9 1

So on one aircraft theres no values and other there is, in the report i insert the microsoft chart and use the row source as the query (Qry AirData) but both of the records are merged together on the same chart on one page, with bizarre bold lines on some bars (bar chart). theres is two pages in the report but both with exactly the same chart! how can i tell the chart object to use the first record data (A330) as one page and A340 as another??

Thx all
Will

 

[Ryath]

huh... the formatting has gone all funny... anyway here is it again...

Aircraft Model BNG BRF CC CF CIR CPF
A330 1 5 1
A340 1 1 9 1

Will

 

[Ryath]

...hmm... didnt work... anyway u get the idea.... roughly. Will