Copy Chart to Clipboard

[Thomas Wieser]

Hi,

how is it possible to copy the active chart in exactly the double size
as on screen to clipboard?

I tried to do it with ActiveChart.CopyPicture



Regards, Thomas

 

[Frank Kabel]

Hi Thomas
why not simply resize the chart in your target application?

 

[Thomas Wieser]

Hi Frank,

why not simply resize the chart in your target application?

Simply because I need the picture in a better quality. So - is there a way?

Regards, Thomas

 

[Frank Kabel]

Hi Thomas
AFAIK no chance. You can only copy what is there

 

[Jon Peltier]

Double the size of the chart, copy it, then shrink it again.

With ActiveChart.Parent
.Width = 2 * .Width
.Height = 2 * Height
.Chart.CopyPicture Appearance:=xlScreen, _
size:=xlScreen, Format:=xlPicture
.Width = .Width / 2
.Height = .Height / 2
End With

- Jon