How do I export a chart in an image format from LibreOffice Calc? [closed]
I want to print some charts from LibreOffice Calc, is there a way to do this?
First time here? Check out the FAQ!
I want to print some charts from LibreOffice Calc, is there a way to do this?
Using Calc you have only two options:
1) Select the chart, Copy and Paste to an image program (lousy quality)
or
2) Select the chart, Export as PDF, Selection, Lossless compression. Then from your PDF reader (I use PDF Xchange Viewer under Windows x86) export to PNG or whatever you prefer.
With LibreOffice 4.0 and up (4.1) introduced a new option to save only the chart. You need to simply right click it and choose "Export as graphic".
Note that 4.0 version have a bug that prevent you from save it as svg image, this was fixed in LibreOffice 4.1.
This is the best answer, but I'd add that the chart must not be selected for the 'export as...' option to come up when you right-click.
A correction to bToasters answer: you don't need to buy anything to get your charts in SVG (or even PNG, TIFF, etc). Just open your ODS file in Gnumeric, click on the Chart and Save as Image.
I hope one day LibreOffice will have this feature as well ;)
copy, paste to draw, right-click → save as image (maybe paste special and explicitly select GDI Metafile) However as the question was about printing: Those images have display resolution (dpi), so not really suitable for printing. If you want to print, just export as PDF and print the PDF.
I would like to expand LiboV's answer a little:
Note: I haven't tried all the export formats, but in my tests this worked well with PNG (bitmap) and SVG (vector).
I get the best quality using these steps: Select your chart in Calc - copy it Open (switch) to a Draw file - paste Size the page appropriately - or - size the page for the graphic you want prior to pasting the chart and zoom the chart to fit:)
I also recommend the following extension - Export As Images -- Export all the Impress slides or Draw pages as images of JPG, PNG, GIF, BMP and TIFF format.
Just a little contribution:
While waiting for a fix, I found that the best way to do this for me (in order to use Calc charts in other documents) was to install a good screenshot app (Shutter is by far the best for Linux) that lets you select a part of the screen.
I then "Page Preview" my spreadsheet in Calc, select "Selection" in Shutter, and select the chart I want. It is directly added to the clipboard, which makes it easy to add in another document, or save in a folder.
Hope this helps!
Drawing off of Pedro's answer: If you go the copy-and-paste route, do the following steps.
If you make it really big first, LO will copy as much of the data as it possibly can. This will result in a better looking image. Unfortunately, from what I can tell, LO doesn't have an "export graph" feature yet.
If you need a super high-quality SVG-type graph of your data, maybe look into Wolfram|Alpha Pro. I believe it costs $3/month (for students), but you can plug your data into it, and it'll let you download a very high-quality chart of your data. This would only be for professional needs, however; a copy-and-paste export like Pedro outlined above would suffice for most usage.
Easy way is to use Print Screen ;-) and e.g. http://pixlr.com/editor/ as a editor
Asked: 2012-02-18 17:25:00 +0100
Seen: 68,512 times
Last updated: Nov 29 '13
Edit data labels in x-axis (interval) [closed]
How can I put two data series with different categories in one chart? [closed]
How can I export .ods files with conditional formatting without losing most of it? [closed]
Equations of Lines on Charts [closed]
How can I expand a chart's data range? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
Here is the issue on Bugzilla: https://bugs.freedesktop.org/show_bug.cgi?id=3 You can say that you are affected by this to try and push it to be fixed in the next release.
And here is a similar question in Ask LibreOffice: http://ask.libreoffice.org/question/2142/save-a-chartgraph-as-image-in-calc/
The bug id=3 shows something completely different.
Sorry, the right link is: https://bugs.freedesktop.org/show_bug.cgi?id=30944 The fix is said to be targeted for LO 3.7, which should be out in February 2013. Thanks for pointing this out! :)
LO3.7 was renamed to LO 4.0. There you can right-click on chart and export graphic to many formats.