Charts drill down

Posted on 2011-10-07
Last Modified: 2012-05-12
I have a pivot chart created in access as a form.
I would like to create drill-down on this chart to show
more detail chart, which is,  when you click on the first chart, the other chart shows up.
Is it possible to do it in Access 2007 , if so how to do it ?
Thanks !
Question by:MPI_IT
    LVL 74

    Accepted Solution

    Pivot Charts do not have a "drill" down feature specifically, so unless an expert here wants to spend the time creating something "custom", you may be out of luck here...

    About the best you could do is create a "Filter Criteria Form" where you selected the criteria.

    But this would not be "Dynaimic" as in a true Drill down, and would require more manual intervention.

    Author Comment

    I already have a criteria form.
    I thought, I can make use of 'on click' event on the chart and I put code to run another chart, but it did not work.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Sorry, because a Pivot Chat in Access is just a "View" you cannot really click on it and do anything.

    But drill down functionality is something I wish MS would include.

    Sorry I could not help more


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now