Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

How to export chart from LibreOffice Calc as PDF

📅 2014-Mar-10 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ export, libreoffice calc, libreoffice draw, pdf, pdfcrop ⬩ 📚 Archive

The straightforward solution to this is:

  1. Click on the chart to select it.

  2. Choose File > Export as PDF. Choose General > Range > Selection. Click Export.

The PDF file produced by this method has a few problems. It includes sheet number at the top and sometimes the content is cropped off at the page margins. Moreover, this produces a PDF that is the size of a A4 page, no matter what is the size of your chart.

A better solution is to:

  1. Click on the chart to select it.

  2. Right-click and choose Copy.

  3. Open LibreOffice Draw and paste there.

  4. Export the selection to PDF, just like above. This PDF does not have the sheet number at the top and the content is not cropped off.

  5. This PDF still is the size of a A4 page. To crop it down its content, use the PDFCrop tool.

Tried with: LibreOffice 3.5.7.2 and Ubuntu 12.04