[Solved+Issue] Export Calc Chart as an Image

Discuss the spreadsheet application

[Solved+Issue] Export Calc Chart as an Image

Postby RossGoodman » Thu Dec 27, 2007 7:50 pm

Is it possible to create an image file from a chart in calc?
I want to put a copy of my chart onto my website.
Thanks in advance.
Ross
Last edited by Hagar Delest on Sat Jul 25, 2009 10:13 pm, edited 1 time in total.
Reason: tagged [Solved].
Ross
----------------------
www.RossGoodman.com
RossGoodman
 
Posts: 1
Joined: Thu Dec 27, 2007 7:48 pm
Location: Scotland

Re: Export Calc Chart as an Image

Postby JohnV » Thu Dec 27, 2007 9:11 pm

You can using Draw. Select the chart so it has green handles, copy & paste into Draw then while still selected do File > Export.
JohnV
Volunteer
 
Posts: 1585
Joined: Mon Oct 08, 2007 1:32 am
Location: Kentucky, USA

Re: Export Calc Chart as an Image

Postby famo » Tue Jan 22, 2008 5:27 pm

i have a question there too:
if I choose to export as .svg the whole text is missing and its even worse, if you have a chart with color gradient in the background.
is this only here or is this generally a bug in OOo? :?:
famo
 
Posts: 48
Joined: Tue Jan 22, 2008 5:06 pm

Re: Export Calc Chart as an Image

Postby kriswarner » Sat Oct 04, 2008 6:31 pm

The easiest way I've found to do this is to save the calc file as a webpage, open that webpage up, and then right click on the image, save as. Very little hassle, though it would be nice if Calc had a feature to save the chart as an image file from within Calc.
OOo 2.4.X on MS Windows Vista
kriswarner
 
Posts: 1
Joined: Sat Oct 04, 2008 6:27 pm

Re: Export Calc Chart as an Image

Postby Cambirder » Sat Oct 04, 2008 7:03 pm

You can paste the image into Writer or Draw as a GDI Metafile, and from there paste it into an image editor to save in what ever format you prefer.
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: Export Calc Chart as an Image

Postby mahela007 » Sat Oct 04, 2008 7:13 pm

you can also export the spread sheet as a PDf file and then use the snapshot tool in adobe PDF. the advantage here is that you will get antialiased graphs
OOo 2.3.X on Ms Windows XP
mahela007
 
Posts: 14
Joined: Thu Oct 02, 2008 3:04 pm

Re: Export Calc Chart as an Image

Postby LexLuthor » Sun Oct 26, 2008 9:16 pm

all that sounds fairly complicated.
In excel you can simply press the shift button and then select edit->copy picture to save a chart as a picture.

your solutions take a lot of time, especially if you notice an error in a chart and have to do all that export stuff again.
OOo 2.4.X on Ubuntu 8.x
LexLuthor
 
Posts: 1
Joined: Sun Oct 26, 2008 9:11 pm

Re: Export Calc Chart as an Image

Postby acknak » Mon Oct 27, 2008 1:31 am

It has been requested, and is currently targeted for OOo "3.x" which probably means sometime in the next year or so.
Issue 21588: export chart as postscript, image (PNG, BMP...) or pdf
You can register there and add your vote (up to two) or comment.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Export Calc Chart as an Image

Postby TomNJ » Tue Oct 28, 2008 3:17 pm

A quick way to do it in 3.0 is to select "Preview in web browser" and then right click the image and save it.

You can also just select the chart and copy/paste it into Photoshop. I think you need to change the Print options to "reduce bitmaps" and set the resolution to the highest you can? The lines aren't anti-aliased, you lose gradients and the text kerning is off sometimes.

I use the export to PDF then take a snapshot because the charts look like crap otherwise.

In my opinion, any work to make it easier to export charts is pointless until the exported charts look better. Until then go the cumbersome export to PDF route.
OOo 3.0.X on Ms Windows XP + Solaris 10
TomNJ
 
Posts: 1
Joined: Tue Oct 28, 2008 2:49 pm

Re: Export Calc Chart as an Image

Postby murphyb » Sat Feb 07, 2009 1:11 am

You can using Draw. Select the chart so it has green handles, copy & paste into Draw then while still selected do File > Export.


Thanks for your answer, JohnV. It is a little roundabout but it worked for me.

I found that when you export, if you click the "Selection" box and you have the chart selected it will output only the chart as the image file which was exactly what I was trying to do. However, I couldn't find any mention of checking this box when I was looking for help so I thought I would add it here.
OOo 2.4.X on Ubuntu 8.x + Windows XP
murphyb
 
Posts: 1
Joined: Sat Feb 07, 2009 1:07 am

Re: Export Calc Chart as an Image

Postby JohnM » Sun Jul 12, 2009 7:52 am

Thanks for the post on how to export a Calc Chart as an image.

I'm using NeoOffice 3 (Mac OSX 10.5) and adapted your method.

I previewed my image in my web browser (Firefox); then Cntrl-click on the chart and selected "copy image" which copies the image to the clipboard. Then I opened Preview.app and select File, New from Clipboard, or Cmd-N which copies the image from the clipboard into a new preview document. from there I do "save as" to save the image in one of the available formats.

Just a little round about but it works!

:bravo:
OOo 3.3.X on Mac OSX 10.7 Lion
JohnM
 
Posts: 9
Joined: Wed Feb 18, 2009 6:31 am

Re: Export Calc Chart as an Image

Postby Dave » Mon Jul 13, 2009 4:56 am

JohnM wrote:Thanks for the post on how to export a Calc Chart as an image.

I'm using NeoOffice 3 (Mac OSX 10.5) and adapted your method.



I'm new to the iMac. In Windows, I'd have copied the image then pasted into an image editor like Photofiltre, or The Gimp. Does Mac have a decent image editor other than GIMP? Also, why NeoOffice? How does their iWorks compare? I'm finding the new spreadsheet, Numbers, a bit of a learning curve, and missing a few items I've been used to.

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: [Solved+Issue] Export Calc Chart as an Image

Postby frankiejol » Tue Nov 09, 2010 4:54 pm

The best workaround I found so far is this:
http://phanvinhthinh.blogspot.com/2010/ ... -draw.html

It basically advises to change the page size before exporting as pdf.
OpenOffice 3.2.1
Ubuntu 10.10
frankiejol
 
Posts: 1
Joined: Tue Nov 09, 2010 2:50 pm

Re: [Solved+Issue] Export Calc Chart as an Image

Postby mriosv » Thu Nov 11, 2010 12:55 am

Right-click the chart, copy.
Then Paste-special have two options:
-Star object Descriptor (XML)
-GDI metafile

Right-click the GDI metafile, copy.
Then Paste-special have four options:
-Draw format.
-SVXB (StarView Bitmap/Animation)
-GDI metafile.
-Bitmap.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
mriosv
Volunteer
 
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests