I have a report which includes a subform which I have made as PivotChart. This displays a bar chart, but I would like to overlay this chart with a second chart which shows a line graph using a set of completely different data...any ideas greatly received.

I tried to do it by linking to an excel chart but this proved a problem when the data in the access tables changed and it wouldn't update the excel chart

Cheers in advance