How to Make a Graph in Word
Word can draw the chart itself, or show one that still belongs to an Excel workbook. Which you pick decides whether the chart can ever be updated.
Two routes, and the choice matters more than the chart type. Insert → Chart has Word draw it and keep the data inside the document. Copy from Excel and paste as a link leaves the data in the workbook, so the chart can be refreshed later. Everything else is formatting.
Route 1: make the chart in Word
Click where the chart belongs, then Insert → Chart. Pick a type from the left-hand list — Column, Line, Pie, Bar and so on — and click OK.
A small spreadsheet grid opens above your document, pre-filled with sample data. Type over it with your own. The detail that catches people: the live range is the shaded area with a blue handle at its bottom-right corner. Drag that handle to take in more rows or columns. Numbers typed outside it are ignored, and the chart simply does not show them.
Close the grid when you are done. The chart stays, and so does its data — stored inside the .docx file. To change it later, right-click the chart and choose Edit Data.
Use this route when the numbers are finished. The document is then self-contained: mail it anywhere, and the chart travels with it.
Route 2: bring a chart over from Excel
If the chart already exists in a workbook, build it there — Excel is better at charts than Word and always will be. Select the chart, copy it, then in Word use Paste Special or the paste options button, where there are five choices. The two that matter:
- Keep Source Formatting & Embed Workbook — copies the data into the document. Self-contained, cannot be refreshed from Excel, and makes the file noticeably larger.
- Keep Source Formatting & Link Data — leaves the data in the workbook. The document holds a picture plus a path back to the file.
Pick Link Data when the workbook keeps changing. To bring the chart current afterwards, right-click it and choose Refresh Data. Word also offers to update links when you open the document.
Linking versus embedding, plainly
| Embedded | Linked | |
|---|---|---|
| Data lives | Inside the document | In the Excel workbook |
| Survives emailing | Yes | Shows last saved picture |
| Can be refreshed | No | Yes, on demand |
| Breaks if the file moves | Never | Yes |
| File size | Larger | Small |
A linked chart in a document you send outside your company is the worst of both: your recipient cannot reach the workbook, so they see a frozen image, while you see a live one and assume they do too.
Formatting that actually helps
With the chart selected, the Chart Design and Format tabs appear, and three buttons sit to its right:
- Chart Elements (plus sign) — titles, data labels, gridlines, legend. Turning data labels on and gridlines off is usually an instant improvement in a document, where nobody is going to measure against an axis.
- Chart Styles (brush) — presets and colours.
- Chart Filters (funnel) — show or hide series without touching the data.
Two habits worth keeping: resize by dragging a corner so the proportions hold, and widen the chart before shrinking the font when category labels crowd.
The monthly report problem
All of the above assumes you are making a chart once. A report you produce every month is a different job. Embedded charts have to be re-entered by hand. Linked charts can be refreshed — but only the charts. The sentence above the chart that says "billings rose 9% on July" has no link and no refresh, and it is the number a reader actually quotes back to you.
That mismatch, rather than the charting, is what makes a recurring document tedious: half of it updates and the other half has to be re-read line by line.
Having the document ask for the chart
Quiriz for Word takes the other approach: write the question in the document where the answer belongs, select it, and press Chart. The answer replaces the words that asked for it. A Figure puts one number inside your own sentence and leaves the words around it alone, which is what makes the prose refreshable too.
Write the report before the month closes by leaving markers — =QUIRIZ.ASK("revenue by month", "chart"), =QUIRIZ.ASK("total billed", "figure") — then press Resolve markers when the data lands. Next month, Refresh all asks every question again: charts gain their new months, the totals in your sentences move, and your headings, numbering and commentary stay exactly where they were. Turn on tracked changes for refreshes and Word shows every figure that moved as a revision you can accept or reject.
Where it does not apply. A one-off chart of eight numbers you already have in front of you is Insert → Chart, and always will be.
Charts in Word that update themselves
Ask a question in the document and get the chart, the table or a single figure back in place — then refresh the whole report next month in one press. Free to start.
Try Quiriz free →