Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to export/save charts as PDF files in Excel?

After creating charts in Excel, you may want to save the chart as PDF for presentations, reports, or for other purposes. So how? And how about exporting multiple charts and saving into one PDF file? This article will show you solutions as below:

Export/save one chart as a separate PDF file in Excel

Export/save multiple charts into one PDF file in Excel

Batch save multiple charts as JPEG/PNG/TIF/GIF images in Excel

Kutools for Excel’s Export Graphics utility can help Excel users quickly export and save all graphics (including pictures, shapes, and charts) as images. And exported graphics can be saved as many formats, such as JPEG, GIF, TIF, or PNG. Full Feature Free Trial 60-day!

ad export graphics 1

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial


arrow blue right bubble Export/save one chart as a separate PDF file in Excel

This method is talking about exporting or saving one chart as a separate PDF file in Excel. Please do as follows:

1. Right click blank area of one chart that you will save as a separate PDF file, and select the Move Chart from the right-clicking menu. See screenshot:

2. In the opening Move Chart dialog box, check the New sheet option, and click the OK button.

Note: By default the new chart sheet is named as Chart 1, Chart 2, …. But you can type a custom chart sheet name into box right to New sheet option. See screenshot above:

3. Now you get into the new created chart sheet, please click File (or Office button) > Save As.

4. In the opening Save As dialog box, specify a destination folder to save the PDF file, Select the PDF (*.pdf) from the Save as type drop down list, and click the Save button. See screenshot:

So far, the specified chart has been exported and saved as a separate PDF file already.

Note: This method will move the specified chart from original sheet into a new created chart sheet.


arrow blue right bubble Export/save multiple charts into one PDF file in Excel

Sometimes, you may need to export and save multiple charts from a workbook. This method will show you the way to save multiple charts into one PDF file in Excel.

1. Right click blank area of a chart, and select the Move Chart from the right-clicking menu.

2. In the opening Move Chart dialog box, check the New sheet option, and click the OK button.

3. Repeat Step 1 and Step 2 to move other charts into new chart sheets.

4. Select these new created chart sheets simultaneously in the Sheet Tab bar. See screenshot:

Notes:

(1) To select multiple adjacent chart sheets in the Sheet tab bar, please hold the Shift key and click the first chart sheet and the last chart sheet;

(2) To select multiple nonadjacent chart sheets in the Sheet tab bar, please hold the Ctrl key and click each chart sheet one by one.

5. Click File (or Office button)> Save As, and then in the opening Save As dialog box, specify the destination folder to save your PDF file, select PDF (*.pdf) from the Save as type drop down list, and click the Save button.

So far, these charts have been exported and saved into one PDF file, and each chart stays in a separate page.


Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for you.

  • Designed for 1500+ work scenarios, helps you solve 80% Excel problems.
  • Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  • Being used by 110,000 elites and 300+ well-known companies.

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Jolynn Haney · 2 months ago
    I would like to export multiple charts to multiple pdf files (each chart to a SEPARATE pdf file). Can I do this with KUTools for Excel?
    • To post as a guest, your comment is unpublished.
      kellytte · 1 months ago
      Hi Jolynn Haney,
      At present Kutools for Excel’s Export Graphics feature can export each chart as a separate image (jpeg, gif, tif, and png). And exporting graphics to PDF files is in the plan list of our development team. You may get this feature of exporting graphics to PDF in near future.
  • To post as a guest, your comment is unpublished.
    David dickson · 2 years ago
    I have a PDF file format that is a chart of names and addresses I need to be able to pull the names and addresses off that chart and to put them into a customer resource management software so I need to convert from PDF to some other format what is the most efficient way