Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4150
  • Last Modified:

Excel Chart, export as vector graphic

Is there a way to export an Excel chart as a graphic , preferably a vector format, eg wmf,dxf, cdr. I want to do that so that I can edit it in a program such as CorelDraw. Apart from capturing the chart on the clipboard as a bitmap, I have not found a way to export it.
0
sjt
Asked:
sjt
  • 4
  • 3
  • 2
  • +2
1 Solution
 
TigerManCommented:
sjt,

If you are using CorelDraw [say version 9.0] then you might consider using Corel Capture - it will snap a shot of any area of the screen that you select, and you can then easily specify the file type etc.

You can fire Corel Capture from the Start Menu [Programs, ?? , Corel Draw, Graphics Utilities, Corel Capture] or from within Corel Photo-Paint [Standard Toolbar, Application Launcher button, Corel Capture]

Hope that helps,

Dave

0
 
TigerManCommented:
Failing that, it is also a simple matter of select your Chart, then Ctrl-C, switch to Corel Draw, and Ctrl-V

Dave
0
 
tureCommented:
If it's ok to use VBA, you may try code similar to this. :

ActiveChart.Export Filename:="c:\test\test.gif", FilterName:="GIF"

ActiveChart.Export Filename:="c:\test\test.jpg", FilterName:="JPG"

ActiveChart.Export Filename:="c:\test\test.tif", FilterName:="TIFF"

Unfortunately, the export method doesn't seem to support any of the vector formats that you mentioned.

/Ture
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
tureCommented:
sjt,

Another method that may help you, if you have PowerPoint installed...

1. Create the chart in Excel
2. Copy the chart
3. Start PowerPoint with a new, blank slide
4. Paste the chart
5. Right-click the pasted chart, select Group-UnGroup, accept the warning

(You are able to edit each part of the object directly in PowerPoint)

6. With all the objects still selected, rigt-click an object and select Grouping-Group
7. Now copy the chart and paste it into Corel Draw

Ture Magnusson
Karlstad, Sweden
0
 
criCommented:
If you do not have Corel, here some alternatives for the raster to vector convertion:

a) Commercial Application: PixEdit
http://www.techsoft.no/index.htm

b) Shareware (Good rating but did not try it)
http://www.zdnet.com/downloads/stories/info/0,,000W1Z,.html

c) Online Applet
http://www.sm.go.dlr.de/~jens/applets/vectorize/

d) 'True Nerd' solution
- Install a postscript printer _driver_ (does not matter if you have no printer)
- Print postscript to file
- Edit this file (assumes that you know where...)
- To print it w/o postscript printer: Well, thats another story... (use Ghostscript or similar)

PS: If you explain why/what you need this for, perhaps a better way can be found
0
 
TigerManCommented:
All comments are appropriate, however, it is evident that sjt has Corel:

"I want to do that so that I can edit it in a program such as CorelDraw"

Dave
0
 
criCommented:
Tigerman, not necessarely, it is evident that sjt is _aware_ of CorelDraw ;-)

0
 
djesseeCommented:
Create the chart and make it rather large.  Save it as a Tiff, Gif, Jpg or whatever format you want.

Now Here's the Catch... :)

If you have CorelDraw, then you have another application called Corel OCR Trace that can help you with this problem and many others.  Take this captures image of your chart, and open it in OCR Trace, then perform a "centerline" trace.  Then save it as a WMF file.

Then you can import it into any environment you need, ungroup it, and then do whatever you need to do.

Oh...I almost forget.  If you put your chart into Powerpoint, then pergorm an "Ungroup" on it, it will then be converted into a bunch of shapes that you can manipulate manually, or expoer as a WMF (vector format) file.  You might be able to copy in Excel, paste to Coreldraw and then ungroup it there, but I'm not sure, since you're pasting across vendors.
0
 
criCommented:
djessee, either you do not read the thread or you are rehashing Tigerman's contribution.
0
 
sjtAuthor Commented:
Ture
Thanks for your help. That solved my problem exactly. I was able to save the chart in a vector format
 The other methods that people suggested, such as using CorelCapture and the Excel Macro for capturing to a jpg, produced  a rasta file and did not provide sufficent resolution
Cheers
SJT
0
 
criCommented:
sjt, from your answer (raster file) I must deduce that you did not try the _vectorizers_ (the one in CorelDraw or the 3 URL's I gave you)
0
 
sjtAuthor Commented:
cri,  I had previously used Corel-Trace but did not get entirely satisfactory results. The quality of the output seems to be dependant on the quality of the bitmap that is vectorised and on the settings applied in Corel-trace. I found that it was necessary to do quite a bit of cleaning up of the line work to get an acceptable result.
Ture's method using Excel, PowerPoint and CorelDraw on the other hand resulted in a perfect copy of the chart in a vector format. No additional editing was necessary. I do intend to check out the three URL's you gave me. Your suggestions were much appreciated.
sjt
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 4
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now