openoffice calc – Export Excel graphs as vector graphics files (e.g. SVGs)? – Super User

When I right click on a graph in Excel the 'Save as Picture...' option only gives non-vector formats (like PNGs and JPGs) as options. The only resource I've found on this is http://www2b.abc.net.au/science/techtalk/newposts/790/topic790744.shtm where no one gives a real answer. Just like the questioner there, I don't mind if it's a multi-step process eg. Excel ->, Open Office ->, SVG or Excel ->, pdf ->, SVG. Though you can indeed copy-'n-paste directely into InkScape you might lose some formatting in the process. Exporting to PDF ensures that the background of your Excel file will be retained as well. Works very well in my experience. Try Gnumeric. It supports exporting graphs to SVG natively. There's a windows version, too. So, the toolchain would be Excel ->, Gnumeric ->, SVG, or even Gnumeric ->, SVG without using Excel. IMHO it's the easiest way to get your graph in SVG. Newer versions of PowerPoint allow you to Save&Send as PDF. Use that feature to create a PDF file, then open that in Inkscape and edit by ungrouping, then resize the page to the drawing and save as SVG. Using Excel 2007 under Windows XP, I also discovered that copied graphs get pasted as bitmaps in Inkscape. This is different than the behaviour of Excel 2003 on Windows 7. I found a workaround -- if you select the cells surrounding the graph (which would include the graph as well) and copy, you can paste a vector graphic in Inkscape just as expected. The only slight downside is that you have to manually remove the grid of excel cells which is left below your graphics. You could try to just copy a graph (Ctrl-C) and paste it in Inkscape (and then save as SVG). It worked for me on Excel 2003, Inkscape (0.48.4) and Windows Vista (Borrowed computer), as at least in Windows the default copy-format seems to be EMF. But then I guess the OS X Clipboard may handle this differently and copy/paste a bitmap instead. To avoid the 'crop the PDF' step mentioned in several answers, you can put the chart on its own Worksheet with an appropriate paper size and zero margins. E.g. in Windows Excel 2007: If there is no size close enough, or you want to be exact, you'll need to create a custom page size. Unlike Word, Excel doesn't let you do that itself, but rather uses the size from the printer driver. It may be best not to have an outline around the chart in the PDF itself: you can choose Format Chart Area | Border Color | No Line. Note that you can also place the PDF directly into your Illustrator document, but in my case any text in the image was turning into garbage. If your chart does not have a large amount of text, a better option might be skipping the EPS step (which turns the font into paths) and manually correcting the garbage text in Illustrator's PDF import. Here is a method using Excel and Powerpoint for Windows. Copy the graph to the clipboard in Excel using the copy command in the home tab of the ribbon. Past special into a blank slide in Powerpoint using the Paste menu in the ribbon. Scroll down and select 'Picture (enhanced metafile)' from the drop down menu in the dialogue box. Then click OK The graph appears in Powerpoint. Make sure the graph is selected then go to Arrange >, Ungroup. A dialogue box will appear... 'This is an imported picture, not a group. Do you want to convert it to a Microsoft Drawing Object?' click yes You are almost there! Make sure the grahp is still selected. Go back to Arrange >, Ungroup and click All of the elements of the graph should now be Powerpoint vector objects. Cheers, enjoy. Source.


Яндекс.Метрика Рейтинг@Mail.ru Free Web Counter
page counter
Last Modified: June 30, 2014 @ 12:00 am