Pie Charts in report (A97)

Topic

New Reply

I am trying to create Pie Charts in a Report; I have created the graph using the following source.

SELECT [LF_Rep 1].[Edge ripple], Count([LF_Rep 1].[Edge ripple]) AS [CountOfEdge ripple], [LF_Rep 1].KeyField
FROM [LF_Rep 1]
GROUP BY [LF_Rep 1].[Edge ripple], [LF_Rep 1].KeyField;

I have then used the

Reply | Quote

Replies

Peter,

You can do this using VBA and DAO. In the OnFormat event of the report, set the colors of the data points explicitly.
I have attached a zipped Access 97 database with an example to show this.

Regards,
Hans

Reply | Quote

Thanks Hans.

I will have a play and see how I get on

Peter

Reply | Quote

With a bit of fine-tuning to sort out parameters it has closed off that report

now on to the next one

Many thanks

Peter

Reply | Quote