Extracting Charts from Excel worksheets

carijansen · #1 08-22-2008, 03:25 AM

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** · #2 08-22-2008, 06:04 AM

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 · #3 08-22-2008, 07:30 AM

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** · #4 08-22-2008, 07:35 AM

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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Charts Moving Around	alexschecter	Excel General	0	07-31-2008 11:40 AM
Excel: Multiple worksheets - comparing text values	lmeinke	Excel General	2	07-02-2008 03:35 PM
Extracting multiple charts	b6fx	Excel Charting	0	04-09-2008 07:55 AM
Extremely slow excel with charts containing large amounts of data	EmnaX	Excel Charting	0	12-19-2007 07:37 PM
Copying Excel Charts into Word	Mary Krysiak	Excel Charting	2	04-15-2007 03:57 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)