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 30-day!

ad export graphics 1

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

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.


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
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 · 8 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 · 8 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