Results 1 to 2 of 2
  1. #1
    pmatush is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    11

    Creating charts with drill down functionality

    Is there a way to create a chart that allows the user to click on a bar or piece of the pie that links him to another chart that shows a detail based on which piece he clicked on. I see that there are 'Drill Into' and 'Drill Out' buttons grayed out when opening a query in pivot chart view, but I think I need to start with a chart in a report.

    Thanks in advance,


    Patrick

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    I doubt it. Reports are not intended to be interactive, although can be to some degree in ReportView (not PrintPreview). The chart control is even less 'smart'.
    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. Drill Down capability
    By Eric@Gopher in forum Access
    Replies: 3
    Last Post: 08-07-2012, 01:01 PM
  2. Replies: 12
    Last Post: 07-20-2012, 08:40 AM
  3. Replies: 2
    Last Post: 02-13-2012, 02:41 PM
  4. Creating charts
    By iamnamja in forum Reports
    Replies: 1
    Last Post: 07-11-2011, 02:39 PM
  5. Semi-colon Functionality
    By TheDeceived in forum Access
    Replies: 3
    Last Post: 09-22-2010, 10:52 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