Exporting an image of multiple super-imposed charts

[Oleg_Troyansky]

Folks,

OK, it's my turn to ask a question... I have a complex chart that's implemented as a combination of multiple charts with transparent backgrounds, plotted one over another... Is there a way (perhaps, via macro?) to export multiple chart images and overlay them in the exported image file? Or, is there a way to export a targeted area of the sheet image (like built-in Snagit) ?

appreciate your help,

Oleg

[#2]

Hi Oleg

What happens when you print the whole sheet? Print it as PDF?

Juerg

[Oleg_Troyansky]

We can print the sheet, or even extract the whole sheet as an image. The problem is - the users need to copy the chart into PPT, without all the other sheet objects.

Would be really nice if I could extract just he chart area...

thanks!

[#4]

Create a hidden sheet that has a copy of just the overlapping charts without the other stuff on it?

[Oleg_Troyansky]

That could possibly work... Thanks!

[shree909]

can you tell like how to create a hidden sheet that can copy all the multiple charts..