[Solved] Charts on New Sheet & Printing Charts

Discuss the spreadsheet application
Post Reply
2CV67oo
Posts: 55
Joined: Sat Nov 27, 2010 11:12 pm
Location: Alsace

[Solved] Charts on New Sheet & Printing Charts

Post by 2CV67oo »

Coming from Excel to OpenOffice & then LibreOffice, I was disappointed to find it apparently impossible to create charts "on a new sheet", which was easy in XL.
I also had a lot of difficulty making tidy prints of charts as it always seemed difficult to define the print zone reliably.

Even Googling didn't bring much encouragement, the least-worst item being:
http://askubuntu.com/questions/47044/ho ... ffice-calc
...which didn't seem to work exactly for me either.

Going on from there though, I found, by trial & error, that it is quite possible to have charts on separate sheets & quite easy to print charts & save tham as .ps files or export them as .pdf files.

To create a chart on a different sheet from the data:
1. Create the chart roughly on the data sheet.
2. Either Copy the chart (if you want to keep it also on the data sheet) or Cut it (if you don't).
3. Open new sheet.
4. Paste chart into new sheet.
5. Align & format the chart on the new sheet - it is dynamically linked to the data sheet, but formatted independently; you can have differently formatted charts on 2 sheets if you want.

To print a chart:
1. It seems easier to put the chart on a new sheet, as above, first.
2. Preferable put it in the top left corner.
3. View > Page Break View > Adjust page break to fit round chart, or vice-versa.
4. Print > General > Selected sheets.

To Create a .ps file with just the chart:
1-4 as above.
5. Print > Options > Print to file.

To export chart as .pdf file:
1-3 as above.
4. File > Export as PDF.. > General > Range > Pages > Whatever sheet your chart is on.

There are probably better ways, but I was pleased to find these, so am posting this in case it helps anybody else...
LibreOffice4.4.2.2 on Ubuntu 15.04.1 & LibreOffice ??? on W8.1 & LibreOffice 3.3.4 on Win7
User avatar
IsabelDalhousie
Posts: 20
Joined: Thu Aug 10, 2017 2:12 am

Re: [Solved] Charts on New Sheet & Printing Charts

Post by IsabelDalhousie »

Thanks for this .... I'm still struggling because the chart sheet doesn't automatically update when the data changes. Is there a setting I need to check?
Apache OpenOffice 4.1.5 running on macOS High Sierra 10.13.6 Arizona time zone
Post Reply