Export of charts to Excel

[shilina_klara]

Hello!

tell me how you can export the graph as a picture, but with a transparent background. I borrowed the code, where there is a part:

if (not objSource is nothing) then

if (pasteMode = "image") then

Call objSource.CopyBitmapToClipboard()

else

Call objSource.CopyTableToClipboard(true) '// default & fallback

end if

Set objCurrentSheet = objExcelDoc.Sheets(sheetName)

objExcelDoc.Sheets(sheetName).Range(sheetRange).Select

objExcelDoc.Sheets(sheetName).PasteSpecial DataType=wdPasteBitmap

and in the excel it is loaded so:

and I need it without a white background:

[marcus_sommer]

I don't think that is possible because a picture will always have a defined background - each pixel has an assigned color. As a workaround you could export the data to excel and creating with them the graph there.

- Marcus