+ 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
    795
    Thank Post
    69
    Thanked 98 Times in 80 Posts
    Rep Power
    42

    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
    10,707
    Thank Post
    829
    Thanked 2,571 Times in 2,188 Posts
    Blog Entries
    9
    Rep Power
    731
    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
    795
    Thank Post
    69
    Thanked 98 Times in 80 Posts
    Rep Power
    42
    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
    10,707
    Thank Post
    829
    Thanked 2,571 Times in 2,188 Posts
    Blog Entries
    9
    Rep Power
    731
    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
    795
    Thank Post
    69
    Thanked 98 Times in 80 Posts
    Rep Power
    42
    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
    795
    Thank Post
    69
    Thanked 98 Times in 80 Posts
    Rep Power
    42
    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, 04:30 PM
  2. Cannot create users in Active Directory
    By WithoutMotive in forum Windows
    Replies: 17
    Last Post: 6th February 2009, 11:20 AM
  3. "Get External Data" not working in Access 2003 or 2007
    By BatchFile in forum Windows Vista
    Replies: 2
    Last Post: 13th November 2008, 11:00 AM
  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, 02:53 PM
  5. Lookup a value in Access
    By laserblazer in forum How do you do....it?
    Replies: 5
    Last Post: 18th January 2008, 11:56 AM

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
  •