Save Chart as image

Discuss the spreadsheet application
Locked
LastWhisper
Posts: 4
Joined: Sat Jan 28, 2017 9:13 am

Save Chart as image

Post by LastWhisper »

Hi,

I'm wondering how to save a chart as image.

I tried to cut and paste it in drawing, but when I try to export as png the entire page is saved not only the chart and I don't know how to crop it.
Openoffice 4.1.2
User avatar
Zizi64
Volunteer
Posts: 11513
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Save Chart as image

Post by Zizi64 »

I'm wondering how to save a chart as image.
...from the Calc application?


The LibreOffice Celc has a function named "Export as Image":
Export graph as picture.png
Just select the graphical object, right click on it, and then click on the "Export as Image " menu item.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
LastWhisper
Posts: 4
Joined: Sat Jan 28, 2017 9:13 am

Re: Save Chart as image

Post by LastWhisper »

I'm using openoffice calc. What's the difference between openoffice and libreoffice ?

I don't have the option to export as image when I right click on the graph.

Basically, I have all the same options, but not export as image.
Openoffice 4.1.2
User avatar
Hagar Delest
Moderator
Posts: 33709
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Save Chart as image

Post by Hagar Delest »

You can copy the chart and paste it in Draw. Then you can either right click and Convert it > To bitmap (save it as a .png file afterward) or To Metafile and then Break it if you need to tweak it. The metafile is a scalable format.

LibreOffice has slightly more features but it's less stable than AOO.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the edit button if your issue has been fixed.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
User avatar
Zizi64
Volunteer
Posts: 11513
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Save Chart as image

Post by Zizi64 »

What's the difference between openoffice and libreoffice ?
The development of the LibreOffice is more faster, therefore it has more new features, it has a littlebit different user interface now.
I am using the LibreOffice since the date of fork. The LibreOffice project started at OpenOfice version 3.3.x - with same version number. The latest LO is the 5.2.5 version, and every main version had 5-6 published subversions. The latest version of the AOO is 4.1.3. So, it shows the speed of the development.
There was (and there is) bug problems with some LO subversions, but generally I can to say: it is a stable office suite. We (at my workplace) are using the LibreOffice.

https://en.wikipedia.org/wiki/LibreOffice#Licensing
Last edited by Zizi64 on Tue Jan 31, 2017 1:46 pm, edited 3 times in total.
Tibor Kovacs, Hungary; LO7.5.8/25.8.5.2 /Win7-10-11 x64Prof.
PortableApps: LO3.3.0-25.8.5.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Richarda44
Posts: 351
Joined: Sat May 24, 2008 6:59 pm

Re: Save Chart as image

Post by Richarda44 »

To save a chart image why not just use the windows snipping tool ?
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop

There's got to be a better way
And for all accountants - The change is coming
User avatar
Hagar Delest
Moderator
Posts: 33709
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Save Chart as image

Post by Hagar Delest »

Richarda44 wrote:To save a chart image why not just use the windows snipping tool ?
It can depend on the quality you need. Bitmap can be fine, scalable format insures better rendering quality.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
Richarda44
Posts: 351
Joined: Sat May 24, 2008 6:59 pm

Re: Save Chart as image

Post by Richarda44 »

Thanks Hagar

Now I see why my snip looked a bit pixelated at 300%. But before blowing it up the snap conveyed all the details I wanted.
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop

There's got to be a better way
And for all accountants - The change is coming
Locked