Excel to PDF Charts Missing — Causes and Fixes

Excel charts can be embedded in worksheets as 'floating' objects or live on their own dedicated chart sheets. Conversion tools handle these differently: **Floating charts not captured.** When a chart is embedded as a floating object within a worksheet, it occupies a position on top of the cell grid. Some conversion tools render only the cell grid and skip floating objects — including charts, images, and other shapes placed above the cells. **Chart sheets not included.** If your Excel file uses separate chart sheets (chart on its own sheet, not embedded in a data sheet), some converters skip these sheets or handle them differently from regular worksheets. **Unsupported chart types.** Some chart types (3D charts, certain combination charts, charts with custom Excel add-in features) may not render correctly in LibreOffice or other non-Microsoft conversion backends. **The chart is outside the printable area.** Excel has a print area setting. If a chart is positioned outside the defined print area, it won't appear in the PDF even though it's visible in Excel's normal view. **Hidden sheets or rows.** If the chart's data source references cells in hidden rows/columns, some converters handle this differently from Excel itself, producing empty charts. **Row height or zoom issues.** Charts with fixed pixel dimensions may not render correctly when the sheet's zoom level or row heights don't match what the conversion tool expects.

Work through these in order for the fastest resolution:

1. 1Convert directly from Excel using Microsoft Excel's built-in Save As PDF function. In Excel, go to File > Save As > PDF, or File > Export > Create PDF/XPS. Excel's own PDF export understands its own chart objects perfectly and captures everything correctly. This is always the first approach to try.
2. 2Check and expand the print area to include charts. In Excel, go to Page Layout > Print Area > Set Print Area. Make sure the print area selection includes all chart objects. If there's no print area set, charts in odd positions may be excluded. Select the entire worksheet and clear any existing print area restrictions.
3. 3Convert chart sheets separately. If you have dedicated chart sheets, try converting the workbook to PDF with Excel's built-in tool and confirm chart sheets are included. If using a third-party tool, check whether it includes chart sheets in the output.
4. 4Move floating charts to their own chart sheets for problematic converters. Right-click the chart > Move Chart > New Sheet. Chart sheets are handled more consistently by some conversion backends. Convert, then check if the chart now appears correctly.
5. 5Try LibreOffice Calc directly (not an online converter) if you're on a system with LibreOffice installed. Open the Excel file in LibreOffice Calc, then export to PDF. LibreOffice's direct export handles more chart types than many online converters.
6. 6For specific missing chart types, try screenshotting the chart from Excel and inserting it as an image into the worksheet (positioned within the print area) if the dynamic chart won't convert. Then re-export to PDF. The image-based approach is a workaround but ensures visual accuracy.

Some Excel chart types are consistently problematic when converting through non-Microsoft backends: **3D charts:** Excel's 3D perspective charts often don't render correctly in LibreOffice-based converters. The 3D perspective is an Excel-specific rendering. Consider switching to 2D equivalents. **Combination charts:** Charts combining bar and line series sometimes render with incorrect element placement. **Treemap and Sunburst charts:** These are newer chart types (Excel 2016+) with limited support in older conversion backends. **Charts using custom data labels with special formatting:** Complex label formatting may render incorrectly or omit label content. For critical charts in these categories, use Excel's built-in PDF export rather than third-party tools.

Building good habits in your Excel workflow prevents conversion problems: - **Set explicit print areas** that include all charts and content you want in the PDF - **Use page breaks** to control how multi-page spreadsheets flow in the PDF - **Keep charts within the data sheet** rather than on hidden sheets if using third-party converters - **Test conversion early** in complex workbooks — don't wait until the final version to discover chart compatibility issues - **Save as .xlsx** rather than .xls — older format files have more compatibility issues with non-Microsoft converters