An Excel workbook contains a dozen worksheets. Each worksheet has tables of raw data and one or two charts that summarize the data visually. You need to send the charts to your manager as a clean PDF, without the underlying data, without the other worksheets, without the gridlines and row numbers that belong in a spreadsheet but not in a presentation. Exporting only the charts saves your manager from scrolling through irrelevant data and presents the information in its clearest form.
The capability to export Excel to PDF with chart-only output is built into Excel, but the controls are distributed across several settings that are easy to miss. Once configured correctly, the process produces a multi-page PDF where each page is a chart, cleanly formatted and ready for sharing.
Selecting Charts for a Chart-Only PDF Export
The first step is to isolate the charts you want to export. Excel can export an entire worksheet as PDF, including all charts on that sheet and all data cells. To export only charts, you can either move the charts to dedicated chart sheets, which are special worksheet tabs that contain a single chart with no data cells, or select only the chart objects before exporting.
Moving charts to chart sheets is the cleaner approach for recurring exports. Right-click a chart and select Move Chart. Choose New Sheet and give the sheet a descriptive name like Sales Chart or Revenue Trend. Repeat for each chart. When all charts are on dedicated chart sheets, group-select those sheet tabs and export. The resulting PDF contains one page per chart sheet, with each chart filling the page.
For ad hoc exports where you do not want to rearrange the workbook, select all the charts on a worksheet by holding Ctrl and clicking each chart. With the charts selected, use the Export or Save As function and choose PDF. Excel prompts you to choose between exporting the entire workbook, the active sheet, or the selection. Choose Selection. Only the selected charts will export.
Configuring Export Settings for Clean Chart Output
Before exporting, check the page setup for each chart sheet or for the worksheet containing the selected charts. Set the page orientation to match the chart aspect ratio. A wide chart benefits from landscape orientation. A tall chart benefits from portrait. In the Page Layout tab, set margins to Narrow to maximize the chart size on the page.
Remove extraneous elements that appear on the printed page. In the Page Layout tab, uncheck the options to print gridlines and headings. These settings affect the printed and PDF output. Gridlines around empty cells and the row numbers and column letters that identify cell positions are useful in a spreadsheet but clutter a chart PDF.
For PDF Charts that will be inserted into other documents, set the chart sheet background to white and remove any worksheet tabs, formula bars, or status bars from the view before exporting. The exported PDF page should contain only the chart on a white background with no spreadsheet interface elements visible. This produces the cleanest result when the PDF is shared or embedded.
Handling Multiple Charts Across Different Worksheets
When charts are scattered across multiple worksheets, the chart sheet approach described above is the most reliable way to collect them for export. Move each chart to its own chart sheet, then group the chart sheet tabs by Ctrl-clicking each one. With the chart sheets grouped, export to PDF. The resulting file has one page per chart in the order the chart sheets appear in the workbook.
If moving charts is not practical, create a new worksheet that serves as a chart collection page. Copy each chart and paste it as a linked picture on the collection page. Arrange the linked pictures vertically. Export the collection page as a single PDF page. The limitation is that all charts appear on one page, which may make them too small if there are many charts.
WukongPDF can process the exported PDF Export file after creation, splitting a multi-chart page into individual pages or cropping each chart to remove excess white space. The browser-based tools let you adjust the output without returning to Excel and re-exporting.
When to Include Data and When to Export Charts Only
Chart-only PDFs are appropriate for presentation and communication. The manager reviewing quarterly results needs to see the trend lines, not the 5,000 data points behind them. The client reviewing a proposal needs to see the projected growth chart, not the underlying assumptions spreadsheet. Removing the data from the shared document focuses attention on the visual summary, which is the purpose of a chart.
Chart-plus-data PDFs are appropriate for verification and audit. The analyst checking the numbers needs to see both the chart and the data that produced it. The regulator reviewing a submission needs to verify that the chart accurately represents the source data. In these cases, export the worksheet with both the data table and the chart, clearly labeled so the relationship between them is obvious.
Automating Regular Chart PDF Exports
If you export the same set of charts on a recurring schedule, automate the process. Excel supports VBA macros that can select specific chart sheets, configure page setup, and export to PDF with a single click. Record a macro of the export steps once, then run the macro for each subsequent export. The time saved compounds with each reporting cycle.
When exporting charts to PDF, the chart formatting as it appears on screen is exactly what will appear in the PDF. Before exporting, review each chart at 100 percent zoom and check for truncated axis labels, overlapping data labels, or legend entries that extend beyond the chart area. These formatting issues are easy to miss in the spreadsheet view but become obvious in the PDF output.
Excel chart templates can standardize the appearance of multiple charts before PDF export. Create a chart template with your preferred colors, fonts, and layout. Apply the template to each chart before exporting. The resulting PDF has a consistent visual style across all charts, which looks more professional than charts with varying formatting exported without standardization.
For charts that will be inserted into other documents, consider exporting each chart as an individual PDF file and then inserting the PDFs into the target document. PDF charts inserted into Word or PowerPoint retain their vector quality and scale cleanly to any size. This approach produces better results than copying and pasting charts directly between Office applications.
Page size of the exported PDF is determined by the chart sheet or worksheet page setup. If the chart appears too small on the PDF page, increase the page margins to their minimum values and set the chart to fill the printable area. For chart sheets, the chart automatically scales to fill the page. For charts embedded in regular worksheets, you may need to resize the chart manually before export.
Dynamic charts that update from changing data sources export as static images of the current state. The PDF captures a snapshot of the data as it exists at export time. If the source data changes tomorrow, the PDF chart remains frozen at the export state. For reports that are updated regularly, the export process should be the final step in the reporting workflow, performed only after all data has been verified and finalized.
Accessible PDFs exported from Excel should include alternative text for each chart. Excel allows you to add alt text to charts through the Format Chart Area dialog under the Alt Text section. Describe the chart purpose and the key trend or comparison it illustrates. Screen readers announce this alt text when they encounter the chart in the PDF, making the chart content accessible to users who cannot see it.
Excel for Microsoft 365 includes an Export feature under File, Export, Create PDF that provides more control over the output than the basic Save As PDF option. The Export feature lets you specify which parts of the workbook to include, set the page orientation per sheet, and choose whether to include document properties and accessibility tags in the final PDF output.
Charts that require frequent updating and re-exporting, consider linking the PDF export to a macro or a Power Automate flow. Automating the export ensures consistency across reporting cycles and eliminates the risk of manual export errors such as including the wrong sheets, forgetting to update a chart before exporting, or applying inconsistent page setup settings.
Charts that use conditional formatting or dynamic color scales based on cell values may appear differently in the PDF than they do in Excel. The PDF captures the chart appearance at the moment of export, including the current conditional formatting state. If the underlying data changes and the conditional formatting adjusts, the PDF chart will not reflect those adjustments unless it is re-exported.
A well-organized chart PDF export process turns hours of manual chart extraction into a repeatable workflow that produces consistent, professional output every reporting cycle without the risk of human error.
| Export Approach | Output | Best For | Limitation |
|---|---|---|---|
| Move charts to chart sheets | One chart per PDF page | Recurring exports; cleanest output | Requires workbook modification |
| Select charts + export selection | Selected charts only | One-time exports | Charts must be on same sheet |
| Chart collection page | All charts on one page | Quick overview | Charts may be too small |
| VBA macro automation | Consistent multi-page PDF | Scheduled recurring exports | Requires macro setup |