Extracting Charts from Excel worksheets

[carijansen]

Hello,

Am hoping that one of the Excel gurus on this forum might be able to help me.

I'm looking for a tools or script (commercial/shareware or freeware), that is capable of extracting just the charts/graphs form Excel 2003 worksheets. Have "googled" a fair bit, but not really found s.th suitable.

Here's the scenario:
Charts appear throughout worksheets sometimes on same sheet as chart data, sometimes shared on worksheets pointing to various data.
As these graph require use in commercial print publishing, the preferred extraction tool would extract to PDF or EPS format (to retain vector data, rather than creating a resolution dependent rasterized image).

many thanks for any leads to tools/scripts

Cari

[Andy Pope]

Charts do have an Export method but the image types are limited.

http://peltiertech.com/WordPress/200...as-image-file/
http://peltiertech.com/WordPress/200...art-procedure/

Is the png image not good enough?

[carijansen]

Thanks heaps for those links Andy, that's definitely a good start

PNG is not a supported file format for commercial print publishing purposes. Basically when it comes to print either the charts as extracted at at least 300ppi resolution, or - and this is preferable - as vector (resolution independent), which .pdf would do.

if anyone else has found other tools, pls. drop in a link here as well, and I can review best option. Thanks so much for your help.

[Andy Pope]

you can create the pdf by printing out the chart. But if you do this for a worksheet chartobject you either get the worksheet included or the chart will change size if you select the object and then print.