How do i export an Excel chart to a PNG image, defining the exact size of the resulting image file?
I need to export some excel charts to PNG to put them on a html page. Due to design restrictions, there's a maximum width (say, 450px) for those PNGs. I've already found a lot of instructions how to export the charts to PNG, but in every case, i had to resize the resulting PNG down to the target dimensions, loosing quality. Is there a way to make Excel use certain dimensions when exporting a chart?
Ways i've tried to create the PNGs:
I'm using Office 2010 currrently.
Modifying the size of the charts inside the Excel file would make it possible to "predict" the resulting PNG image size, but it would be great if there's a way of setting the image size without resizing the chart itself, e.g. to create PNGs with different, but pre-defined sized based on the same chart.
There's a useful tool named XL toolbox that allows to "publish" charts with a defined print size using pt, mm or in. This isn't exactly what i'm needing, since the tool seems to resize the image, too, with a slight loss of quality.