Results 1 to 3 of 3
  1. #1
    clancy76 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2014
    Posts
    25

    Chart gaps in Access

    Hey all - I've created a simple chart that plots out the average of a certain value for each month. Works fine, but if no values were entered for a specific month, there is a gap in the chart. Apparently there is a way to connect gaps in Excel (see the video below), but I can't figure out a way to do it in Access. I was under the impression Access and Excel use the same chart object, so is there a way to connect gaps? Looked around the forums a bit and I did not see this question addressed, apologies if it's been answered already.

    https://www.youtube.com/watch?v=40Wd3Wafa0w

  2. #2
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    The problem is that Access "displays" data differently than Excel. In Excel, if you have a date with no data, you still have a row for it, it's just left empty. In Access, however, if there's no data, those rows (Records) don't even exist.

    Example
    DATE VALUE
    1/1/2015 100
    1/2/2015
    1/3/2015 150
    1/4/2015
    1/5/2015 200

    In Excel, the above data looks just like that, in Access, however, you get the following:
    DATE VALUE
    1/1/2015 100
    1/3/2015 150
    1/5/2015 200

    As you can see, there aren't any gaps to fill. The 1/3/2015 data appears immediately after the 1/1/2015 data with no 1/2/2015 appearing at all.

    The only way I know of to do what you're asking, is to "fill in" the blanks with dummy data, either in the Table itself, or after the fact using VBA, and neither of those are likely to be easy.

  3. #3
    clancy76 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2014
    Posts
    25
    Valid point Rawb - I didn't think about the fact that the record doesn't actually exist in an Access table the way it would in a spreadsheet. Not the end of the world, just would have been a slight aesthetic improvement if the dots could have been connected(in a simple fashion like in Excel). Thanks for taking the time to answer.

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

Similar Threads

  1. Replies: 9
    Last Post: 01-29-2013, 06:44 PM
  2. Closing Up Gaps in a Chart
    By Paul H in forum Programming
    Replies: 1
    Last Post: 08-03-2012, 02:10 PM
  3. Query for gaps in date ranges
    By kagoodwin13 in forum Queries
    Replies: 6
    Last Post: 03-19-2012, 07:00 PM
  4. Removing Gaps from Report
    By caseym in forum Reports
    Replies: 2
    Last Post: 03-25-2011, 04:07 PM
  5. Replies: 2
    Last Post: 07-12-2010, 05:39 AM

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 - Senior Forums