Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a pop up solution!
Hi everyone. I am an Excel user since ver 2.1, but have a question.
Maybe an old dog needs to learn a new trick! ;) Anyway, here is the situation. I built an enterprise dashboard using Excel, and next to my charts, I have data tables displayed from other tabs via the Camera tool. This is because the data is in dynamic ranges that change daily (e.g. display last 30 days sales, etc.) My boss hates the data being displayed by the chart, and want them in another place. I know I could set up hyperlinks, but what I really would like to do is click or hover to display the data table. I also am limited in that macros won't do, since my boss hates to see the enable macro box come up. SO, what I thought I'd do is put the camera tool objects into cell comments. Well, that doesn't work. Does anyone have any other great ideas? Thanks for your help! MP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My solution | Excel Discussion (Misc queries) | |||
Is there a simple solution? | Excel Worksheet Functions | |||
SumProduct Solution? | Excel Worksheet Functions | |||
Struggling for a solution | Excel Worksheet Functions | |||
Solution please | Excel Discussion (Misc queries) |