How to make a Straight Table Chart fully transparent?

[UzunovM93]

Hi all,

I have a cluster of objects (different metrics) in 1 place and I am trying to add a transparent table on top of these objects that contains all of the metrics' information amalgamated so that the users can just right click and send to excel in 1 go rather than having to export each and every metric separately. I've tried multiple ways of doing this (hide columns -> doesn't show in Excel; changed font to match the background -> when sent to excel it comes with the 'background' font). Any ideas?

[Brett_Bleess · Accepted solution]

Only thing that comes to mind would be a hidden object that has what you want to export and a button object with the other object the users can click that will perform the export on the hidden object contents, the only thing of which I am unsure is whether the hidden object will prevent things from working or not, you will have to confirm whether or not that might work, best of which I can think.

Regards,
Brett