To insert a line graph in Word, select Insert > Chart > Line, choose a line-chart style, and click OK. Replace the sample data in the worksheet that opens, then close the worksheet to update the chart. You can then add a title, labels, and formatting from Word’s chart tabs. A line graph is useful for showing how values change across ordered categories, especially dates or time periods.
The steps below are for Microsoft Word for Microsoft 365 on Windows. The chart commands are similar in Word for Mac, though the ribbon layout can differ slightly. Word calls these visuals line charts in its menus, but they are commonly called line graphs too.
What You’ll Need
- Microsoft Word for Microsoft 365 on Windows or Mac. A desktop version is best if you want full chart-editing controls.
- Your data, organized in a small table. Put category labels, such as months, in the first column and each data series in its own column. Include a header for every series.
- A clear idea of what the chart should show. Decide which values belong together and what categories should appear along the horizontal axis before you begin.
You do not need to create a separate Excel file first. Word inserts a chart with a small embedded worksheet for entering or pasting the data.
Step-by-Step
- Prepare and check your data. Arrange the information in rows and columns, with one row of headings and one column of category labels. For example, put Month in cell A1, Product A in B1, and Product B in C1. List January, February, and later months down column A, with the matching values in the other columns. Keep each series in a consistent unit, such as dollars or units sold. Remove empty header cells and check that numbers have not been stored as text. A neat layout makes it easier for Word to interpret the series and labels correctly.
- Choose where to place the chart. Click in the document where you want the graph to appear. If the chart should sit between paragraphs, place the cursor on a blank line. If you want it beside text or a picture, you can change its wrapping after insertion; starting on a blank line is usually simpler. You can move the chart later by selecting its outer border and dragging it, or by cutting and pasting it into another part of the document.
- Open the chart gallery. On the Windows ribbon, select Insert > Chart. In the Insert Chart window, choose Line in the category list. Word displays several line-chart subtypes, including options with markers and stacked lines. On a Mac, use Insert > Chart and select a line chart from the chart gallery; some Mac builds present the gallery slightly differently. If you do not see Chart, check that you are using the desktop Word application rather than a restricted browser view.
- Select a suitable line subtype. Choose a standard 2-D line for the usual comparison across categories. Select a line with markers if readers need to identify individual values, such as monthly measurements. A stacked line is intended to show cumulative contributions and changes in totals, so do not choose it for ordinary side-by-side comparisons. Avoid a 3-D style for most reports because perspective can make values harder to judge. Click OK to insert the selected chart.
- Replace the sample information. Word inserts a chart and opens an embedded worksheet containing example values. Select the existing labels and numbers, then enter or paste your own data into the corresponding cells. Put category labels in the first column and series names in the top row. For instance, the first column might contain quarters, while the next two columns contain revenue for two regions. Do not paste a formatted table that includes unrelated notes or blank rows; copy only the rectangular range that belongs in the graph. The chart should update as you replace the sample values.
- Set the chart’s data range. Check the colored outline around the worksheet cells that Word is using. If it does not include all your data, drag the range handle at the bottom-right corner of the outline to include the missing rows or columns. If the graph includes extra sample categories, reduce the outlined range to the cells you need. Include the headings as well as the values so the chart can use your series names and category labels. When the data range looks right, close the worksheet window or return to the document. The chart remains in Word and reflects the data you entered.
- Check which way the data is plotted. Look at the chart legend and horizontal axis. If Word has treated each row as a separate series when you wanted each column to be a series, select the chart and open Chart Design > Switch Row/Column. On Mac, select the chart and look for the equivalent Switch Row/Column command on the Chart Design tab. Use this only when the existing arrangement is the reverse of what you intend. For example, with months in the first column and products across the top, each product will usually be a separate line and the months will be the category labels.
- Add a useful title and labels. Select the chart, then choose Chart Design > Add Chart Element. Use Chart Title to add a title, and select an axis title if readers need a description of the horizontal or vertical values. Choose Data Labels only when exact values are important and the chart will remain readable. Click the placeholder text in the chart to replace it with wording that explains the data, units, or time period. A title such as Monthly Orders by Region is more informative than Chart Title.
- Format and position the finished graph. With the chart selected, use Chart Design to choose a style or color scheme, and use Format to adjust elements such as outlines and text. Keep the lines distinguishable and the text large enough to read at the chart’s final size. To resize, drag a corner handle so the chart keeps its proportions. Use the Layout Options button beside the chart to choose how text flows around it, such as In Line with Text or a wrapping option. Save the document and review the chart in Print Layout or Print Preview to confirm it fits the page.
Common Mistakes
Choosing a line chart for unordered categories. A line connects neighboring points, which implies an order or progression. Months, dates, and stages are natural categories for a line graph. If you are comparing unrelated groups, such as departments or product names with no meaningful sequence, a bar or column chart may communicate the comparison more clearly.
Using the wrong orientation. If the legend contains dates and the horizontal axis contains product names, the chart may have interpreted rows and columns in the opposite way from what you expected. Check the data layout and use Chart Design > Switch Row/Column when appropriate. Do not try to fix it by repeatedly changing colors or editing labels; correct the series orientation first.
Leaving sample data or headings in place. A graph can look complete while still showing Word’s example categories, values, or series names. Check the entire horizontal axis, legend, and plotted values before sharing the document. Also confirm that the selected worksheet range includes all your real data and none of the sample cells.
Making the graph too crowded. Too many lines, point markers, gridlines, and data labels can obscure the trend. Use a few relevant series, descriptive headings, and labels only where they help. If the values differ greatly in scale, a single vertical axis can also make a smaller series appear almost flat; consider whether separate charts would make the comparison clearer.
Resizing from a side handle. Dragging a side handle can stretch the chart and distort its proportions. Use a corner handle to make it larger or smaller without changing its shape, then inspect the chart at the size it will have on the printed or shared page.
Tips
- Use consistent intervals. If your data tracks time, list periods in chronological order and do not skip an interval without a reason. The line’s direction is easier to interpret when the categories are ordered logically.
- Name series clearly. Put concise series names in the first row of the worksheet. A reader should be able to identify each line from the legend without guessing what Series 1 means.
- Include units in context. Say whether values are dollars, percentages, people, or another measure in an axis title or chart title. If every series uses the same unit, one clear axis label is generally enough.
- Choose markers intentionally. Markers help show individual observations when there are only a modest number of points. With many closely spaced points, markers may overlap; a simple line can be easier to read.
- Keep color meaningful. Use colors with enough contrast and do not rely on color alone to distinguish lines. Clear legend names, markers, and line styles can help readers viewing a printout or a screen with limited color.
- Keep an editable source. The chart’s worksheet stores its data within the document. If the values are important or need frequent updating, keep a separate source spreadsheet as well, and note where the authoritative figures are maintained.
Troubleshooting
The chart does not update after editing. Make sure you changed the worksheet attached to the chart, not a separate Excel file. Click the chart, choose Chart Design > Edit Data if that command is available, and check the cell range again. Confirm that new values fall inside the outlined range. Close the worksheet or switch back to Word so the chart can refresh.
Some categories or lines are missing. Open the chart’s data again and inspect the outlined range. Extend it to cover the missing rows or columns, including the relevant headers. If the range is correct but the wrong items appear as lines, use Switch Row/Column and check the legend. Make sure blank rows or columns have not split the data into separate blocks.
The chart shows a line at zero or a gap. Empty cells can affect the way a line is drawn. Select the chart and open Chart Design > Select Data, then choose Hidden and Empty Cells in the dialog if that option appears. Choose whether empty cells should appear as gaps, zeros, or connected points, based on what the missing data actually means. Do not show missing measurements as zero unless zero is genuinely the correct value.
The title, legend, or axis labels are missing. Select the chart and use Chart Design > Add Chart Element to add the element you need. If the text appears but is difficult to see, select it and adjust its font size or color from the formatting controls. A narrow chart may also hide or crowd elements; widen it or simplify the labels.
The graph is difficult to move or text jumps around it. Select the chart and click the Layout Options button. Choose In Line with Text for predictable placement within a paragraph, or select a wrapping layout if the chart should sit beside text. If dragging is awkward, cut the selected chart, click the intended location, and paste it there. Save before making substantial layout changes.
You cannot find the chart commands. In Word for Windows, the Chart Design and Format tabs appear when you select a chart. If they are not visible, click the chart’s border rather than a nearby paragraph. On Mac, select the chart to reveal its chart-formatting tabs. If your organization or Word version limits chart editing, open the document in desktop Word for Microsoft 365.
Frequently Asked Questions
Can I make a line graph in Word without Excel?
Yes. Use Insert > Chart > Line in Word. Word opens an embedded worksheet with sample data, where you can type or paste the values. You do not need to create a separate Excel workbook, although Excel may be used to edit the chart data.
How do I add another line to the graph?
Select the chart and open its data worksheet using Chart Design > Edit Data. Add a new series name in a new column or row, enter its values for the matching categories, and expand the chart’s selected data range if Word does not include the new cells automatically. Check that the new series uses the same units if you intend to compare it on the same axis.
Can I change the line graph after inserting it?
Yes. Select the chart to access Chart Design and Format. You can edit its data, switch rows and columns, change the chart type, add chart elements, and adjust its appearance. To change the graph to a different type, use Chart Design > Change Chart Type and choose the replacement.
Why does Word show categories instead of dates?
Word may be treating the date column as text labels, or the worksheet range may not include the date cells in the expected position. Check that dates are in the first column or row used for category labels and that the chart includes that range. For a standard line chart, dates can appear as ordered category labels; they do not always behave like a continuous date axis.
Can I insert a line graph in Word for the web?
Available chart-insertion and editing options can vary by Word for the web account and document. If you cannot find the chart gallery or the controls you need, open the file in the desktop Word app and use Insert > Chart. After editing the chart on desktop, save the document so the updated graph is available in the browser version.
Related
- Microsoft Access vs Excel: Which Tool Should You Use?
- Where Did Undo and Redo Go in Excel?
- think-cell in Excel: Find the Ribbon Tab and Data Links
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Area Charts: How to Shade Selected SectionsYes. In Excel for Microsoft 365 on Windows, you can shade selected sections of an area chart by…
- Build an Org Chart in Excel: Steps, Layout, and Design TipsTo build an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy…
- Excel Dashboard Practice Exercises for Real-World SkillsExcel dashboard practice exercises should take you from a clean data table to a useful, interactive summary: calculate…
- Radar Chart in Google Sheets: How to Create and Read OneTo make a radar chart in Google Sheets, put category names in the first column and each data…
- Shade Area of a Chart in Excel: Methods and TipsTo shade the area beneath a line in Excel, select the chart, go to Chart Design > Change…
- Excel Chart Data Table: Can You Change Its Text?Yes—but you generally cannot edit values by typing directly into an Excel chart’s data table. In Excel for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.