+ Reply to Thread
Results 1 to 2 of 2

Interactive Excel Graph???

  1. #1
    Registered User
    Join Date
    06-23-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Interactive Excel Graph???

    I'd be incredibly grateful if you could let me know if this set up is even possible and if so how I go about doing it.

    In simple terms I have a large data set of invoices which relate to different areas of the institution at which I work. I have produced line graphs reflecting how many of these invoices belong to each area on a daily basis.

    Is it possible to add a feature to the graph that would allow users to double click on the data point and this would then open a new sheet with the full details of the invoices that have been used to generate this data?

    If that isn't possible then is it possible to at least let users double click anywhere on the graph and this will bring up the most recent set of data used? I've looked everywhere and it doesn't appear that this is a functionality of Excel and I'm assuming someone is going to say this is impossible. If so what could do this???

    Cheers for any help!
    Last edited by baileyhsi; 06-28-2010 at 05:10 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Interactive Excel Graph???

    You can write code in the charts events.
    http://www.computorcompanion.com/LPMArticle.asp?ID=221

    You might be able to use a pivot table/chart. The table can provide drill down information.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1