hi, MP !

... next to my charts, I have data tables displayed from other tabs via the Camera tool
... the data is in dynamic ranges that change daily (e.g. display last 30 days sales, etc.)
... boss hates the data being displayed by the chart, and want them in another place
... what I really would like to do is click or hover to display the data table
... limited in that macros won't do, since my boss hates to see the enable macro box come up.
... 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?

[it's only *wild-ideas*, but]...
i think you could define a [dynamic] name using desref(...) and others...
and *assign* that name [in the formula bar] to your pasted image [with camera tool]

sorry if i can not be more accurated, but i can't *see* from, where and what [tabs/ranges/rows/columns/...]
so... if any doubts [or further information]... would you please comment ?

regards,
hector.