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
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