I have a macro that exports charts to excel. When I export a chart as a Bitmap (obj.CopyBitmapToClipboard), its only exports the body of the graph and not the heading given.
Captions are not exported. You can try the macro from this post. Change tableToExport.CopyTableToClipboard true with tableToExport.CopyBitmapToClipboard true if you want to copy the image of the table instead of the data.
