While creating a vbscript macro to export something to excel, is it at all possible to export multiple different "Fast Change" charts you have selected for one particular chart such that they all show up correctly?
For example, i have a straight table which defaults to a normal straight table view, but I also have Fast Change implemented which includes a bar chart view and a pie chart view. Is there is way to code the vbscript to say something like "export the table first...offset a row...load the bar chart image below it....offset a column...load pie chart image.... etc
Is this possible or do you have to create (and hide) separate charts for each of these exports?
Thanks