pdf to excel8 min read

How to Create Charts in Excel from PDF Data (2026 Guide)

Upload the PDF to PurePDF's PDF to Excel tool, download the XLSX, clean headers and number formats, select the data, then use Insert > Charts to build your chart.

SM
Sarah Mitchell

Introduction

Most of the data worth charting does not start life in a spreadsheet. It arrives as a PDF: a bank statement, a sales report, an invoice summary, a government statistics release, a supplier price list. The numbers are all there, but you cannot chart a PDF. You need the table in Excel first, and then you need it clean enough that Excel treats numbers as numbers.

This guide covers the whole workflow: converting the PDF table to an editable spreadsheet, fixing the issues that usually break charts, and building column, line, and pie charts that actually look right. The only tool you need besides Excel is a free PDF-to-Excel converter, and no signup is required.

Step 1: Convert the PDF table to Excel

Start with the conversion, because retyping a table by hand is slow and error-prone, and copy-pasting from a PDF usually pastes everything into one column or scrambles the rows.

  1. Open PurePDF's PDF to Excel converter: https://www.purepdf.net/pdf-to-excel
  2. Upload your PDF file. The tool reads the tables in the document and converts them into an editable XLSX spreadsheet, preserving rows, columns, and table structure.
  3. Download the XLSX file and open it in Excel (or Google Sheets — the steps below work in both, with the same menu names in most cases).

A few tips for a cleaner conversion:

  • If the PDF has several tables, convert the whole document first and delete the sheets or sections you do not need, rather than trying to convert one page at a time.
  • Scanned PDFs are images, not text. If your PDF is a scan, run it through OCR first so the converter can read the numbers; otherwise you will get blank or garbled cells.
  • Check the converted sheet against the original PDF before charting. One misread digit in a source table becomes a wrong bar in your chart, and nobody will notice until the presentation.

Step 2: Clean the data before you chart

This is the step most people skip, and it is the reason most PDF-to-Excel charts look broken. Spend five minutes here and the chart practically builds itself.

Remove repeated headers and footers

PDF reports repeat the table header on every page, and the converter faithfully brings those repeated header rows into your spreadsheet. Delete the duplicate header rows so only one header row remains at the top. Also delete page numbers, footnotes, and "continued on next page" lines that landed inside the data.

Fix numbers stored as text

Converted numbers often arrive as text: Excel left-aligns them, and charts either ignore them or plot zeros. Select the number column, and if you see a small warning icon, choose "Convert to Number." For stubborn cases, use Data > Text to Columns > Finish, which forces Excel to re-evaluate the cells as numbers. Currency symbols and thousand separators (like $ and commas) can also block conversion — use Find and Replace to strip them from the data range, then format the column as Currency or Number afterward.

Fix dates and blanks

Dates that arrive as text will not plot on a time axis. Select the date column and use Data > Text to Columns with the Date format that matches your data (for example, MDY). Delete fully blank rows inside the table, and fill or remove blank cells in the series you plan to chart — gaps in a line chart usually mean a blank cell in the source range.

Give the table a proper header row

Make sure the first row holds short, clear labels (for example, Month, Revenue, Expenses) with no merged cells. Charts use that row for series names and axis labels, so "Q1 2026 Sales ($)" is a better header than a merged title cell spanning three columns.

Step 3: Pick the right chart type

The chart type should match the question you are answering, not just the data you happen to have.

Column chart: comparing values across categories

Use a column chart when you compare values across categories — monthly revenue, sales by region, expenses by department. It is the safest default for PDF report data, because most report tables are category-plus-value tables.

Line chart: showing change over time

Use a line chart when the story is a trend: revenue over twelve months, prices over quarters, usage over weeks. Line charts need the time column sorted in order; if your PDF table lists months out of order, sort the sheet first or the line will zigzag.

Pie chart: showing parts of a whole

Use a pie chart only when you show how a total breaks down — budget shares, market share, expense categories — and only with a handful of slices. A pie chart with fifteen slices is unreadable; if you have more than six categories, use a bar chart instead.

Bar chart: long category names

If your categories have long names (supplier names, product descriptions, city names), a horizontal bar chart reads far better than vertical columns, because the labels get room to breathe.

Step 4: Build the chart in Excel

With clean data, the actual chart takes about a minute:

  1. Select the data range, including the header row. Do not select the title or footnote rows.
  2. Go to Insert > Charts and pick your chart type — Clustered Column, Line, or Pie.
  3. Excel creates the chart on the same sheet. Check immediately that the right column became the categories (usually the first column) and the right columns became the series. If the chart looks transposed, use Chart Design > Switch Row/Column.
  4. Click the chart title and type a plain, specific title, such as "Monthly Revenue, Jan–Jun 2026." A chart without a title forces the reader to guess what it shows.
  5. Add data labels only if they help. For a column chart with a few bars, labels make values readable at a glance; for a chart with dozens of points, labels just add clutter.

Step 5: Format it so it looks professional

Small formatting choices separate a chart you can present from one you have to apologize for.

  • Keep the axis scales honest. Do not truncate a column chart's value axis to exaggerate a small difference — start at zero unless you have a clear reason not to, and say so if you do.
  • Use one color per series, and keep the palette restrained. Two or three muted colors beat a rainbow.
  • Remove chart junk: heavy gridlines, 3D effects, and decorative backgrounds add nothing. A clean chart with a title, labeled axes, and a legend is enough.

Common problems and fixes

The chart plots zeros or blanks. A column in the source range is stored as text. Convert it to numbers as described in Step 2, then re-select the chart data.

The categories show as 1, 2, 3 instead of month names. The category column was not included in the selected range, or it contains dates Excel read as a series. Re-select the range including the first column, or right-click the chart, choose Select Data, and set the category labels manually.

The line chart zigzags. The time column is not sorted, or dates are stored as text. Sort the data and fix the date format.

One table became several tables. Long PDF tables split across pages sometimes convert into separate blocks. Stack them into one continuous range (one header row, all rows below) before charting.

Numbers look right but totals are wrong. A repeated header row or a totals row is hiding inside the data range. Delete both, then check the sum against the total printed in the original PDF.

Frequently asked questions

Can I chart a PDF directly in Excel? No — Excel cannot chart a PDF file. Convert the PDF table to XLSX first, clean the data, then chart the spreadsheet. The conversion step is the whole trick.

Is the PDF to Excel conversion free? PurePDF's converter is free to use online with no signup and no watermark on the output: https://www.purepdf.net/pdf-to-excel

What if my PDF table has merged cells or multi-line headers? Unmerge the header cells and give each column a single short label. Merged cells are the most common reason a converted sheet charts badly.

Can I do this in Google Sheets instead of Excel? Yes. Upload the XLSX to Google Drive, open it with Google Sheets, then use Insert > Chart. The chart types and cleanup steps are the same.

Conclusion

Creating charts from PDF data is a three-part job: convert the table, clean the data, then chart it. The conversion takes a minute with a free tool, the cleanup takes five, and the chart itself takes one. Most of the work — and most of the mistakes — live in the cleanup step, so do not skip it. Start with your PDF at https://www.purepdf.net/pdf-to-excel, get the numbers into a clean spreadsheet, and build the chart from there.

Ready to pdf to excel?

Use our free online tool to process your files securely in high quality. No sign-up required.

Open pdf to excel Tool

Continue Reading