Results 1 to 2 of 2
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    569

    Closing Up Gaps in a Chart

    I have a bar chart graph that reads data in a table. It is filtered by two combo boxes specifying the date ranges. This works fine except when there is a gap for days that have no data. The chart shows the missing days as just blanks. I would like the chart to close these gaps and not show the missing dates.



    Any suggestions?
    Thanks, Paul

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,028
    Perhaps exclude dates that don't have associated data? Need to better understand data and graph structure.

    I best analyse graph issues by examination. If you want to provide db follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Query for gaps in date ranges
    By kagoodwin13 in forum Queries
    Replies: 6
    Last Post: 03-19-2012, 07:00 PM
  2. Removing Gaps from Report
    By caseym in forum Reports
    Replies: 2
    Last Post: 03-25-2011, 04:07 PM
  3. Closing a form through VBA
    By ghostmachine in forum Forms
    Replies: 4
    Last Post: 12-13-2010, 01:57 PM
  4. Replies: 2
    Last Post: 07-12-2010, 05:39 AM
  5. query to show gaps in a date field
    By Lockrin in forum Database Design
    Replies: 1
    Last Post: 05-28-2010, 10:48 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