Excel chart -> PDF -> LaTeX but need to remove white space

Question

I converted an Excel chart to a PDF file by Save As.. PDF in Excel. It looks good, but there is a lot of whitespace/margin on top and bottom which I need to get rid of. The only way to do so seems to be by using Acrobat professional which I don't have. Is there a free way to do this? I use Windows by the way.

Though if worded as “I have a pdf that I want to include in LaTeX, how can I (automatically) trim it”, I would consider the question on-topic. — Caramdir, May 09 '11 at 16:10

score 6 · Answer 1 · edited Mar 20 '17 at 10:18

You can get the size right in Excel before saving to PDF - see my answer on superuser, copied below for convenience:

To avoid the "crop the PDF" step mentioned in several answers (on superuser), you can put the chart on its own Worksheet with an appropriate paper size and zero margins. E.g. in Windows Excel 2007:

Select chart, from pop-up menu choose Move Chart... | New Sheet
On the new Chart Sheet, Page Layout | Margins | Custom Margins, and zero all
Resize the chart to the desired size by dragging its bottom-right corner
See the resulting size from Chart Tools | Format | Size
Select a close size from Page Layout | Size, and adjust as necessary

If there is no size close enough, or you want to be exact, you'll need to create a custom page size. Unlike Word, Excel doesn't let you do that itself, but rather uses the size from the printer driver.

Page Layout | Size | More Paper Sizes | Print..., select a printer whose driver lets you create custom page sizes - most normal PostScript or PDF drivers do
Options... | Advanced... | Paper Size | PostScript Custom Page Size
Set the size, taking care to get the units right and swap width and height (Excel prints as landscape by default)

It may be best not to have an outline around the chart in the PDF itself: you can choose Format Chart Area | Border Color | No Line.

score 6 · Accepted Answer · edited Jan 24 '12 at 21:44

6

You can use the commandline tool pdfcrop. For this you need perl.

edited Jan 24 '12 at 21:44

lockstep

250,273

answered May 08 '11 at 08:15

Marco Daniel

95,681

It doesn't work for Windows. – P.A May 08 '11 at 08:18
@P.A I changed the link – Marco Daniel May 08 '11 at 08:20
Spent 3 hours looking for this. Thanks! – simon Sep 17 '12 at 14:30

score 4 · Answer 3 · answered May 08 '11 at 08:27

For Windows install a Perl, eg from http://www.activestate.com/perl and then you can use pdfcrop <file> which creates a <file>-crop.pdf. You can rename the file or use the new one.

Alternatively use the trim option for \includegraphics together with clip it cuts of the defined border.

score 4 · Answer 4 · answered May 08 '11 at 09:13

4

This is more of a Superuser question than a Latex question. You could also use Briss which doesn't require Perl.

answered May 08 '11 at 09:13

ipavlic

8,091

score 0 · Answer 5 · answered May 08 '11 at 11:55

0

You might want to consider using the new inkscape pdf import option. It even allows you to edit the picture. Be aware though that the result is not optimal for editing.

answered May 08 '11 at 11:55

Paul de Vrieze

146

score 0 · Answer 6 · answered Jan 24 '15 at 12:02

0

In Excel, Page Setup, uncheck Center on Page - Vertically. Sheet will justify to the top.

answered Jan 24 '15 at 12:02

PeteF

1

1

Welcome to TeX.SX! Can show an example, please? – Jan 24 '15 at 12:29

Excel chart -> PDF -> LaTeX but need to remove white space

6 Answers6

Linked