Excel 3-Line Chart: Create and Format Three Series

To create a three-line chart in Excel for Microsoft 365 on Windows, put the category labels in the first column and the names and values of your three data series in the next three columns. Select the full range, then choose Insert > Insert Line or Area Chart > 2-D Line. Excel plots one line for each series.

What an Excel 3-line chart shows

A three-line chart displays three related data series across a shared set of categories, such as three products’ monthly sales, three temperatures measured over time, or three teams’ weekly scores. Each series becomes a separate line, and the horizontal axis shows the categories while the vertical axis shows the values. A legend identifies which line belongs to which series.

The phrase usually means a chart with three data series, not a special chart type called a three-line chart. It is also different from a 3-D chart: for ordinary comparisons, choose a standard 2-D line chart. Three-dimensional chart effects can make values harder to compare and are not needed to plot three lines.

A line chart is most useful when the categories have a meaningful order, especially dates or stages. It helps readers see direction, turning points, and whether the series move together. If the horizontal values are independent numeric measurements whose spacing matters, a scatter chart may be a better fit; a line chart generally treats its horizontal labels as categories.

Arrange the worksheet data

Use a simple rectangular table with one header row. For example, put Month in A1, Product A in B1, Product B in C1, and Product C in D1. Put Jan, Feb, Mar, and Apr in A2:A5, then enter each product’s value in the matching row across columns B through D. Your complete chart data range is A1:D5.

Keep the labels and values aligned by row: a value in the February row should describe February for every series. Use descriptive, distinct column headers because Excel will use them as the legend labels. Avoid blank header cells, merged cells, and completely empty rows or columns within the table; these can cause Excel to interpret the range unexpectedly.

Before charting, check that the value cells contain numbers rather than numbers stored as text. Currency symbols and percentage formats are fine when applied through cell formatting, but inconsistent text entries such as n/a mixed into a series can affect plotting. If a value is genuinely unavailable, leaving the cell blank is often clearer than entering zero, since zero means an actual measured value of zero.

Create the chart step by step

Select the data, including the headers and category labels. In the example, select A1:D5.
Choose Insert > Insert Line or Area Chart on the ribbon.
Under 2-D Line, choose Line for plain lines or Line with Markers to show a point at each category.
Check that the chart contains three lines and that the legend names match the column headers.
Click the chart title and replace the placeholder with a title that explains the comparison, such as Monthly Sales by Product.

Excel typically reads the first row as series names and the first column as category labels when the selected range is laid out as described. The chart appears as an embedded object on the current worksheet. Drag its border to move it, or drag a corner handle to resize it. On Excel for Mac, the Insert ribbon has the same general line-chart choices, though ribbon placement and wording can vary slightly by release.

Choose the right line style and labels

Use Line when the overall trend matters more than the individual observations. Use Line with Markers when readers should be able to see the exact positions of the recorded categories, particularly when the series has only a few points. Markers on a chart with many dates can make the display crowded, so plain lines may be easier to read for dense data.

Make the three series visually distinct with contrasting colors and, if useful, different marker shapes. Select a line and use the Format Data Series pane to change its line color, width, dash type, or marker options. Keep the colors consistent with any labels or explanations used elsewhere in the workbook. Avoid relying only on subtle shades that are difficult to distinguish on a projector or for readers with color-vision differences.

For a clean chart, retain the legend and add axis titles when the units are not obvious. Use Chart Design > Add Chart Element to add a chart title, axis titles, legend, or gridlines. Data labels can help when there are only a few points, but putting a label on every point across three long series often creates clutter. A focused title and readable axis units are usually more useful than a large number of labels.

Set up the axes and scale

The vertical axis scale can change how dramatic the lines appear. Excel may choose a minimum and maximum automatically based on the plotted values. If small differences matter, an automatic scale can be appropriate; if the chart is meant to show values relative to a meaningful baseline, consider whether the vertical axis should start at zero. Do not change the scale merely to exaggerate a difference, and make any nonzero baseline clear to readers.

To adjust the vertical scale, right-click the value axis, choose Format Axis, and use Axis Options in the pane to set bounds or units. The available settings depend on the data and chart. For date categories, Excel may use a date axis; in Format Axis, check Axis Options and the Axis Type choices if the spacing looks surprising. A text axis spaces categories evenly, whereas a date axis can reflect the intervals between dates.

For example, monthly readings from January through April normally have regular intervals. If the dates are irregular—perhaps January 1, January 2, and March 1—equal spacing and time-proportional spacing tell different visual stories. Choose an axis treatment that matches what you want the reader to infer. If exact numeric spacing is essential, consider a scatter chart with lines rather than forcing a category-style display.

Fix common chart problems

Only one or two lines appear: Check that all three value columns were included in the selection and that each column contains numeric values. Choose Chart Design > Select Data to inspect the listed series.
The months appear as separate lines: Excel may have interpreted rows as series rather than columns. Select the chart and choose Chart Design > Switch Row/Column. Then confirm the legend shows the three series names and the horizontal axis shows the categories.
The legend says Series 1 or Series 2: Include the header row when selecting data, or use Chart Design > Select Data to edit a series name and its values.
The horizontal axis shows 1, 2, 3 instead of labels: In Chart Design > Select Data, check the Horizontal (Category) Axis Labels range and select the cells containing the intended labels.
A missing value appears as zero or as a gap: Decide whether the cell means zero or unknown. For the chart’s treatment of empty cells, open Chart Design > Select Data > Hidden and Empty Cells and choose an appropriate display option.
The lines look flattened or one series dominates: Review the units and ranges. If one series is in thousands and another is in decimals, a shared axis may obscure the smaller values. Separate charts or a carefully explained secondary axis may be clearer than silently changing the comparison.

When editing the source data, a chart based on a normal contiguous range usually updates as values change, but new rows added outside the original selection may not appear automatically. Converting the source range to an Excel table with Insert > Table can make expanding data easier to manage; check that the chart includes the added rows after extending the table.

When a different chart is better

A three-line chart works well when the series share the same units and can sensibly use one value axis. If the series measure unrelated quantities—for example, revenue, temperature, and customer count—putting them together can imply a comparison that the units do not support. Separate charts are often more honest and easier to interpret.

If the goal is to compare each category’s contribution to a total, a stacked chart may answer the question better, though it makes the individual series’ changes harder to compare. If the goal is to compare only a few categories, a clustered column chart can emphasize category-by-category differences. Choose based on the question: a line chart emphasizes movement and pattern across an ordered sequence, not simply the fact that there are three sets of numbers.

Also distinguish a three-series chart from a chart with three observations. One series containing three values is still one line, not three lines. To get three lines, the data must contain three separate series—usually three value columns with their own headers.

Frequently Asked Questions

How do I add a third line to an existing Excel chart?
Select the chart and choose Chart Design > Select Data. Under Legend Entries (Series), choose Add, then set the series name and the cell range containing its values. Confirm that its values correspond to the same category rows as the existing lines.

Why does my Excel line chart show only one line?
The selected range may contain only one value column, or Excel may have interpreted the rows and columns in the opposite direction. Use Chart Design > Select Data to review the series, and try Switch Row/Column if the categories and series are reversed.

Can I make a line chart with exactly three lines?
Yes. Include exactly three value series in the selected data range. If Excel adds an unintended series, remove it through Chart Design > Select Data; if the range includes four value columns, Excel may plot four lines.

How can I show dots on all three lines?
Choose Line with Markers when creating the chart. For an existing chart, select it and use Chart Design > Change Chart Type, then choose Line with Markers. You can also format individual series through Format Data Series.

Can each line have a different color?
Yes. Select a line, open Format Data Series, and choose its line color; repeat for the other series. Use clearly distinguishable colors and keep the legend visible so readers can identify each series.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.