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!
Bookmarks