Ask Your Question
2

Save a chart/graph as image in Calc? [closed]

asked 2012-04-25 07:23:33 +0100

penyuan gravatar image

Hello,

In Micro$oft Excel, there is an option in the right click menu of a chart to save it as an image. Is there similar functionality in LibreOffice Calc? Right now I have to save my Calc document as *.xls, open it in Excel, then save my chart as an image that way, which is somewhat cumbersome to say the least.

Thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 18:05:08.443307

Comments

I just wanted to point out that this question is a duplicate of: http://ask.libreoffice.org/question/37/how-do-i-export-a-chart-in-an-image-format-from/ There might be some more options / tips there.

chtfn gravatar imagechtfn ( 2012-08-09 07:18:47 +0100 )edit

Hi Penyuan Maybe you should change your choice of best answer as things have evolved. This would make this question more up to date and more helpful for other users. Cheers

chtfn gravatar imagechtfn ( 2014-02-04 02:30:54 +0100 )edit

7 Answers

Sort by » oldest newest most voted
3

answered 2013-11-29 12:04:44 +0100

PhoneixS gravatar image

Now that LibreOffice 4.1 have meet the light (2013-11-01), you can use a right click and "Export as graphic" to save the chart as an image in all its formats (inclusive svg, that have been fixed in this release).

edit flag offensive delete link more

Comments

4

answered 2013-01-06 17:38:54 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

This question is now irrelevant. The "Export as graphic" option is included in the upcoming version 4.0 (which can be tested as a Beta build in http://www.libreoffice.org/index.php/download/pre-releases/)

Currently a Chart can be exported in a number of bitmap formats (PNG, TIF, etc) and even in Windows Metafile format. An existing bug currently prevents exporting to SVG (https://bugs.freedesktop.org/show_bug.cgi?id=59083)

edit flag offensive delete link more

Comments

@Pedro I am glad to hear this important feature is finally coming, and really hope the SVG bug would be fixed before release of 4.0 since it would be my preferred format. Thanks!

avamk gravatar imageavamk ( 2013-01-06 17:51:27 +0100 )edit
1

Now with 4.1, the bug have been fixed. I have added a new answer but I think that could be better if you upgrade your question with this information.

PhoneixS gravatar imagePhoneixS ( 2013-11-29 12:06:58 +0100 )edit
2

answered 2012-04-25 09:12:42 +0100

mikebibo gravatar image

You can copy (or cut) and paste your chart into a LibreOffice Draw page, and then, in LibreOffice Draw, select the chart, and export it with File>>Export. In the Export dialogue box, choose your graphics format and remember to check the 'selection' box.

It's still a bit cumbersome, but at least it's all done within LibreOffice.

Perhaps a feature request to allow these export options directly from Calc for chart objects?

edit flag offensive delete link more

Comments

1

+1 on having an export option. Preferably do it right, like Gnumeric which allows to save as PNG, JPG, PS, EPS, PDF and better yet: SVG!

Pedro gravatar imagePedro ( 2012-04-25 10:48:40 +0100 )edit

@mikebibo Thanks! I do like that I can at least do all of this within LibreOffice. But this feature should really have been implemented by now! Is there a dedicated feature request page for LibreOffice?

penyuan gravatar imagepenyuan ( 2012-04-25 11:32:48 +0100 )edit
2

answered 2012-04-25 17:08:47 +0100

rrbd gravatar image

For that we have Enhancement Request "Bug 30944 - Allow exporting a single chart (or other object) to different formats (PDF, SVG, PNG, JPG), target document with object size"

edit flag offensive delete link more
1

answered 2013-01-06 16:08:42 +0100

Hendrik Maryns gravatar image

An easy solution from Bug 30944: select the chart, choose File -> Export as pdf -> selection.

edit flag offensive delete link more
1

answered 2012-04-25 09:03:38 +0100

Pedro gravatar image

Is that a new feature in MS Office 2010? You can also request a new feature for LibreOffice ;)

Meanwhile the easiest solution is to paste into any image editor/viewer and save in your favorite file format. Personally I use the free IrfanView (it is light and fast) but you can use Gimp :)

edit flag offensive delete link more

Comments

@Pedro I believe that has been possible since at least M$ Office 2003, if not 2000!

penyuan gravatar imagepenyuan ( 2012-04-25 11:31:38 +0100 )edit
1

@penyuan: I can't manage to do it either in Excel 2003 or 2007. Can you tell me how to do it?

Pedro gravatar imagePedro ( 2012-04-25 11:43:29 +0100 )edit

@Pedro I can't remember how to do it in 2003 (it has been too long!), but in 2007 you should be able to just right click on a chart, and choose the "Save as Image" option.

penyuan gravatar imagepenyuan ( 2012-04-25 21:12:21 +0100 )edit
1

@penyuan, no you can't. There is no option to Save as Image. You can Copy as Picture (in Office 2003) but you need to paste it somewhere... That is why I'm asking if it is a new feature in Office 2010

Pedro gravatar imagePedro ( 2012-04-25 21:27:55 +0100 )edit

@Pedro Sorry my memory is definitely failing me then! Yeah I guess this must be a 2010 feature... sorry about the confusion.

penyuan gravatar imagepenyuan ( 2012-04-25 21:46:22 +0100 )edit

@penyuan, no apologies required ;) This means that LibreOffice is not that far behind MS :)

Pedro gravatar imagePedro ( 2012-04-26 00:02:51 +0100 )edit
0

answered 2014-11-29 20:58:52 +0100

As of November 2014, I am still running LibreOffice 3 on Linux and do not have direct chart graphics export capability, but there is a fairly easy workaround. With Inkscape installed on the computer, I export the chart from Calc to a PDF file, then extract the chart from the PDF using Inkscape. This allows one full freedom to manipulate the graphics in vector format, then export as PNG or save as SVG for use in other applications.

  1. Click on the chart in LibreOffice Calc to select it; eight small, green squares appear around the edges.
  2. In the menu bar, click File > Export as PDF...
  3. In the PDF Options dialog, select Range: "Selection", then click on the Export button and save the PDF file.
  4. Start up Inkscape and import the PDF file thus generated. It should contain only the chart, not the spreadsheet, with all graphics in a single group.
  5. Ungroup everything and delete the page header and footer text, if it is there, plus any objects not needed for your target application.
  6. Some objects, such as grid lines and tick marks on the axes, may not be visible, because they have no fill or stroke assigned to them, but this can be corrected in Inkscape with the Fill and Stroke toolbox.

Once the fix-ups are done, save the image in SVG format, and if desired, export a copy in PNG format at the desired scale. Using vector graphics allows the chart image to be scaled practically without limit, yet preserving smooth, clear appearance at all scale factors.

Free Inkscape binaries are available for most popular operating systems, including Linux, Mac OS X, and Microsoft Windows.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2012-04-25 07:23:33 +0100

Seen: 34,649 times

Last updated: Nov 29 '14