Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pie Charts in report (A97)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pie Charts in report (A97)

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

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pie Charts in report (A97)

    Thanks Hans.

    I will have a play and see how I get on

    <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Peter

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pie Charts in report (A97)

    With a bit of fine-tuning to sort out parameters it has closed off that report <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    now on to the next one <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    Many thanks <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>


    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •