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.
EDIT:
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.
EDIT 2:
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.