Results 1 to 3 of 3
  1. #1
    BobW2961 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    16

    line chart on report

    A plc sends the level of water in a tank to my access database every 5 mins. The table has three fields. Record number, and date are autofill and the level field contains the level of the tank in inches at the time of the sample.
    I have a query for the table that grabs all of the records for the last 2 weeks.


    I would like a report that from left to right is the date and time of the sample and vertically would be the level of the tank. These values would be connected and end up being a line chart.

    I do this with ease in excel, but can't figure out how to do it with the access chart tool. I keep getting quarter 1, 2,3 and 4 and north, south, east, and west. Don't know where it is getting this when I selected date and level as the two fields for the chart.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Use the chart wizard to guide you thru the chart build.

  3. #3
    BobW2961 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    16
    I am using the wizard. I select my query, then add the two fields from the query. I then select Line Chart. It then shows me that it is using the sum of the levels and charting by the month.
    I don't want any sums and I want a level charted for every date and time which is every 5 mins.
    If I double click on the field and select none for the summary selection, then it won't continue. Says the data field must be summarized.

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

Similar Threads

  1. Stacked column and line chart
    By Soumya in forum Programming
    Replies: 1
    Last Post: 10-14-2015, 09:28 AM
  2. Line chart in access report
    By drp in forum Reports
    Replies: 2
    Last Post: 11-29-2011, 09:37 AM
  3. line chart not showing lines
    By ajetrumpet in forum Reports
    Replies: 0
    Last Post: 09-11-2010, 05:55 PM
  4. Replies: 2
    Last Post: 07-12-2010, 05:39 AM
  5. Line-Bar Chart Issue
    By santoshpk in forum Reports
    Replies: 0
    Last Post: 03-17-2009, 02:47 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