8

I want to save (or 'Publish') an Excel 2010/2013 chart to a PDF file whose dimensions will be exactly those of the chart - not a full white page with the chart on it.

Can this be done somehow?

(Here's a tutorial on how to export a PDF from a chart - which suggests you use Adobe Acrobat to crop the white surroundings. But can't Excel to just not output them?)

A solution requiring a VBA macro (for printing a selected chart while setting the page size to the chart size) would be acceptable, if not what I'm hoping for...

einpoklum
  • 10,666

3 Answers3

5

I think I figured it out. In Excel, highlight the portion, chart or table you wish to publish to PDF. Then File=> Save As...In the "Save As" dialog Box, rename the document in "Filename" and then in the "Save As Type" window, grab the pull-down menu and click the "PDF" line. AT this point, a PDF dialog Box appears. Click "Options" and then click "Selection" then "OK" then "Save" And voila! You can also modify "Orientation" after you've highlighted the subject area to better suit the final output.

Jim Beyer
  • 61
0

It was troubling me for a long time. I found a way to do this.

  • Select the chart.
  • From the menu choose page_layout => margin. Then page setup window will appear. From there you can choose left, right, up, down margin to 0 or other values.
  • You can also change page orientation to landscape.
  • I hope this will help you to export the chart dimension area to pdf. If there is a border in the exported pdf then from the chart outliner choose "No outline"

enter image description here

Al-Alamin
  • 101
-1

On Excel 2010 you can just select the chart you want to print and go to File > Print. This will automatically select the option to "Print the selected chart" (I'm used to a Spanish version of Excel so I don't know the actual value in English) and fit it to the page.

Excel 2010 also has built-in "Save as PDF" support, just select the PDF Printer from the Printers drop-down list.

kenkh
  • 329