+ Post New Thread
Results 1 to 6 of 6
General Chat Thread, Creating Charts in Access in General; Hello All, hoping to pick your collective brains here, I have never learned how to use Microsoft Access properly (my ...
  1. #1
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    1,018
    Thank Post
    105
    Thanked 144 Times in 114 Posts
    Rep Power
    52

    Creating Charts in Access

    Hello All,

    hoping to pick your collective brains here,

    I have never learned how to use Microsoft Access properly (my secondary school could only afford Lotus Approach when i did my GCSEs in 2001) and I have downloaded the Microsoft Desktop Call Tracker for our Reception staff to use. I have pretty much adapted this for our own personal needs, but there is one thing we would like, and I just can't seem to figure out how to do it. I have setup a query table that shows all calls between a specified date, but what we would like is for it to Produce a pie Chart from the "Status" column/field. At the moment I can copy and paste it into excel where it does some nice CountIF's and creates the chart, but all I would like it to do is count the Amount of Active, Closed and Overdue calls in that period and make the Pie chart in Access.

    Could anyone shed some light on how to do this (step by step please) so that I can get this one snigly little bit working.

    Thank you very much

    Garry

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    This of any help:


  3. Thanks to SYNACK from:

    BKGarry (19th June 2012)

  4. #3
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    1,018
    Thank Post
    105
    Thanked 144 Times in 114 Posts
    Rep Power
    52
    that's good @SYNACK but again I am stuck with the fact the values are Text and not Numerical, i will fiddle tomorrow me thinks

  5. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    Just use a formula like the countifs in a new query that converts it into numbers then use that as the data source.

  6. Thanks to SYNACK from:

    BKGarry (19th June 2012)

  7. #5
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    1,018
    Thank Post
    105
    Thanked 144 Times in 114 Posts
    Rep Power
    52
    Quote Originally Posted by SYNACK View Post
    Just use a formula like the countifs in a new query that converts it into numbers then use that as the data source.
    I will try in the morning. Thank you again

  8. #6
    BKGarry's Avatar
    Join Date
    Mar 2006
    Location
    Kent
    Posts
    1,018
    Thank Post
    105
    Thanked 144 Times in 114 Posts
    Rep Power
    52
    Update,

    It worked, but only for a pie chart with a count of the text values, no percentages. but yay it worked. Thank you @SYNACK



SHARE:
+ Post New Thread

Similar Threads

  1. gantt chart in excel
    By econtent in forum Windows
    Replies: 3
    Last Post: 21st April 2009, 05:30 PM
  2. Cannot create users in Active Directory
    By WithoutMotive in forum Windows
    Replies: 17
    Last Post: 6th February 2009, 12:20 PM
  3. "Get External Data" not working in Access 2003 or 2007
    By BatchFile in forum Windows Vista
    Replies: 2
    Last Post: 13th November 2008, 12:00 PM
  4. Creating mailboxes in exchange 2007 when a user is created in AD on another server
    By thesk8rjesus in forum Network and Classroom Management
    Replies: 2
    Last Post: 5th September 2008, 03:53 PM
  5. Lookup a value in Access
    By laserblazer in forum How do you do....it?
    Replies: 5
    Last Post: 18th January 2008, 12:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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