2

I exported a chart from a Microsoft Excel spreadsheet by selecting the chart, the File > Export > Create PDF/XPS document, with the following options:

enter image description here

The result is nice except that:

enter image description here

How can I export the figure so that the surrounding blank space is crop out? I'm OK if the solution requires to change the chart itself.

My original chart is Excel looks like this:

enter image description here

This is the output that I would like to get:

enter image description here

(I cropped the PDF manually using BRISS):

enter image description here

I use Microsoft Excel 2013 with Windows 7 SP1 x64 Ultimate.

Improve this question

1 Answer 1

Reset to default
2

You're likely seeing either or both of:

  1. Page layout > Page setup > Margin > Custom Margins in Excel
  2. The empty cells surrounding your graph: I suggest you "Define a print area".

enter image description here

enter image description here

Improve this answer
4
  • Page layout > Page setup > Margins in Excel did the trick, I didn't think it would apply for select areas. Awesome, thanks!
    – Franck Dernoncourt
    Aug 26, 2014 at 17:43
  • =) That edit is likely a bit slanted against Excel, but still shows it well.
    – Hannu
    Aug 26, 2014 at 17:48
  • Hmm actually Page layout > Page setup > Margins in Excel does the trick when both the figure's height and width is larger than the page's height and width. Otherwise there is still some whitespace around, even when setting margins to 0 :-/ Defining a print area didn't help either.
    – Franck Dernoncourt
    Sep 1, 2014 at 2:03
  • I can imagine this to depend a bit on which version you're using.
    – Hannu
    Sep 1, 2014 at 16:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .