Results 1 to 2 of 2
  1. #1
    intifad is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    2

    Preparing report/chart

    I have a problem with preparing report from data that are stored like in attached file. I want to prepare report or (even better) chart showing how number of engaged employees changed within time for each project.
    The best option would be to prepare line chart consisting of
    Horizontal axis - Time


    Vertical axis - Number of employees
    Colours of lines - each colour of line assigned to one project (ProjectA, ProjectB, ProjectC etc.)

    But I would be extremely grateful for any other hints too.
    Attached Files Attached Files

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    There is a a control that you can add to a form that is called the Chart Control. If you run the Wizard while adding a Chart Control to a form you will likely get what you need. However, you are going to need some queries to base your chart on.

    I would start by creating a SELECT query that retrieves all of the records you want included in the chart. Consider that criteria, maybe some date criteria, as you create a query that produces the Count for your vertical axis. Then, consider that same criteria as you create another query that Groups the projects together. At the end, you will want to JOIN the two queries in a way the include the count of projects. Perhaps you can join on Project ID. Start with the criteria. Maybe the criteria is "Active Projects".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Chart grouping in a report
    By james28 in forum Reports
    Replies: 8
    Last Post: 03-01-2014, 10:33 PM
  2. Replies: 10
    Last Post: 08-29-2013, 09:21 PM
  3. generate a chart report
    By smahdih in forum Reports
    Replies: 4
    Last Post: 11-28-2011, 02:39 PM
  4. Ways of preparing data for graphs
    By ajetrumpet in forum Queries
    Replies: 0
    Last Post: 09-11-2010, 10:26 PM
  5. Pie Chart Design for Report
    By maggioant in forum Reports
    Replies: 0
    Last Post: 10-13-2009, 03:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums