ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-22-2008, 03:25 AM
carijansen carijansen is offline
Registered User
 
Join Date: 22 Aug 2008
Location: Australia
Posts: 2
carijansen is on a distinguished road
Question Extracting Charts from Excel worksheets

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
Reply With Quote
  #2  
Old 08-22-2008, 06:04 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
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?
__________________
Cheers
Andy
Reply With Quote
  #3  
Old 08-22-2008, 07:30 AM
carijansen carijansen is offline
Registered User
 
Join Date: 22 Aug 2008
Location: Australia
Posts: 2
carijansen is on a distinguished road
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.
Reply With Quote
  #4  
Old 08-22-2008, 07:35 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
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.
__________________
Cheers
Andy
Reply With Quote
Reply

Bookmarks

Tags
charts , extract

New topics in Excel Charting


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

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

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


All times are GMT -4. The time now is 06:07 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0