Results 1 to 14 of 14

Thread: Charts (2003)

  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Charts (2003)

    I have a table which contains a field called Defect Codes. I've been asked to create a pie chart showing the percentages of each defect for a given period. I've created a query which asks for the start date and end date, and also gives me the defect codes, but I've never created a chart in Access before so I would appreciate some guidelines. Thanks.

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

    Re: Charts (2003)

    When you click New in the Forms or Reports section of the database, one of the options is the Chart Wizard. The Wizard will ask you a series of questions, then create the chart for you.
    You can also create a form or report in design view, and select Insert | Chart. After dragging a rectangle, the Chart Wizard will start, as above.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    I managed to create a chart, but they didn't explain exactly what they want, so it's more complicated. I used a Complaints table (which I didn't create) to collect the data. Two fields in the table are Defect Code and Category. In the defect codes there are codes. The categories are either Defects or Paperwork. They are wanting a pie chart to show the percentage of Defects and Paperwork, but also the defects is to be split down to show the percentage of Defect Codes. So if 75% of the complaints are Defects and 25% are paperwork, we want to show what % of each defect code the 75% is made up of, if that makes sence.

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

    Re: Charts (2003)

    You can create a query that selects the category, or the defect code if the category is "Defects", and use this query to create the chart from.

    I have attached a database with two different pie charts on a form.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    Thanks again Hans, that's just what they want.

  6. #6
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    I was wrong, that's not what they want, but it wasn't explained properly. Apparently, they want to show how many defects are down to what code, and how much paperwork is down to what code. I've managed to get the chart to give me the right info. How do I get the legends to say Defects due to ?, and Paperwork due to?

    Rob

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

    Re: Charts (2003)

    You could chenge the definition of the Code field in the query to

    Code: [Category] & " due to " & [DefectCode]

  8. #8
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    That hasn't changed anything.

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

    Re: Charts (2003)

    Could you be a tad more specific?

  10. #10
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    I get a Circular Reference caused by Alias error

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

    Re: Charts (2003)

    Where did you enter it? It works in the query qryTesty in the demo database I attached earlier in this thread.

  12. #12
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    If I leave Defect Code in the query and add Code: [Category] & " due to " & [DefectCode] as an extra field, it works in the query but not in the chart. It just shows the defect codes so we don't know which is which (paperwork or defects). But if I remove the original field 'Defect Code' and rename 'Code' to 'Defect Code', I get the circular reference

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

    Re: Charts (2003)

    Does the attached do what you want?

  14. #14
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Charts (2003)

    I couldn't find any differences between your demo and my table/query/chart, so I did them all again and this time it worked. Thanks again Hans.

Posting Permissions

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