I am using the VBA api to automatically export charts. Originally, I exported them as EMF files and by turning the chart background to ‘no fill’ I could get the backgrounds of the exported charts to be transparent. However, when I do the exact same export on the same charts but as PNGs instead, the charts come out with white backgrounds.
Does anyone know how I can get the charts to export as PNG files (or any web suitable image format), and keep their transparent background? As I am sure that this file format should be able to handle transparency.
Any help would be greatly appreciated. And thanks to the developer for this great piece of software!