Chart Clarity - Difference copy to clipboard vs Export to file

[#1]

Hi,

I am trying to copy the chart to excel. Could see a difference in clarity.

Method 1: copy to clipboard as a image and pasted in Excel file, clarity is very low.

Method 2: When using method: export to jpeg file the image quality is nice.

But what I am looking is to get the same clarity of image when using Method 1(copy to clipboard as a image).

Sample file with sample dummy data attached here with.

Any suggestions please. Thanks.

Regards,

Qlikshare

[#2]

Hi,

Any suggestions on getting same clarity while using copy bitmap to clipboard please?

Thanks,

Qlikshare

[jonathandienst · Accepted solution]

You need to use Paste Special and paste it as a device-independent bitmap.

[#4]

Many thanks. Looks great, could you please help to suggest how to do same through macro for "paste special device-independent bitmap.".

Currently in macro, am using copy bitmap to clipboard using below code:

     Set chartToExport = ActiveDocument.GetSheetObject("CH01")

     Set chartProperties = chartToExport.GetProperties

     chartToExport.CopyBitmapToClipboard

'caption

     chartCaption = chartToExport.GetCaption.Name.v

'Paste  chart

     Sheet.Paste Sheet.Range("A1")

Any suggestions how to do "paste special device-independent bitmap", please.

Thanks.

Regards,

Qlikshare

[#5]

Hi,

Many thanks for sharing about this paste special option which helped.

Just managed to do this paste special using macro now.

Thanks again.

Regards,

Qlikshare