How to export/save charts as PDF files in Excel?
Microsoft Excel is a powerful tool for data analysis and visualization, and one of its key features is the ability to create charts. However, once you've created these charts, you may need to export or save them as PDF files for sharing, printing, or archiving purposes. This article will guide you through the process of exporting or saving charts as PDF files in Excel.
- Export/save one chart as a separate PDF file
- Export/save multiple charts as separate PDF files with Kutools for Excel
- Export/save multiple charts into one PDF file
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.
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.
Export/save multiple charts as separate PDF files with Kutools for Excel
If you need to export multiple charts as separate PDF files, "Kutools for Excel" is a powerful add-in that can simplify this process. With the "Export Graphics" feature in Kutools for Excel, you can quickly export all charts or specified charts from your worksheet as PDF files. Additionally, this feature supports exporting various types of graphics (such as shapes, images, etc.) into PDF or multiple common image formats (such as PNG, JPEG, etc.), significantly enhancing the flexibility and efficiency of graphic exports.
After installing Kutools for Excel, please do with the following steps:
1. Click "Kutools Plus" > "Import & Export" > "Export Graphics", see screenshot:
2. In the "Export Graphics" dialog box, configure the following operstions:
- (1.) Select "Charts" from the "Types" drop down;
- (2.) Select the charts in the "Graphics list" box that you want to export.(All records are selected by default.)
- (3.) Choose a folder to save the exported files in the "Save directory" field;
- (4.) Select "PDF" from the "Export format" drop down list;
- (5.) Finally, click "OK" button.
Result: Kutools will save each selected chart as a separate PDF file in the specified folder. See screenshot:
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:
(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.
Conclusion
Exporting or saving charts as PDF files in Excel is a valuable skill that can enhance your ability to share and present data effectively. By following the steps outlined in this guide, you can ensure that your charts are exported in the desired format, ready for sharing or printing. If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials to help you master Excel.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
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!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite ā Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license ā set up in minutes (MSI-ready)
- Works better together ā streamlined productivity across Office apps
- 30-day full-featured trial ā no registration, no credit card
- Best value ā save vs buying individual add-in