Line 3 of a Graph in Excel: How to Find and Format It

Charts & pivot tables · Updated November 22, 2026

In an Excel chart, “line 3” usually means the third data series—the third set of values drawn as a line. Its exact identity depends on the chart’s source data and series order, so check the legend or open Chart Design > Select Data to confirm which values it represents.

What “Line 3” Usually Means

A line chart can display several series at once. For example, a chart comparing monthly sales for three stores may have one line for each store. In that case, “line 3” is likely the third store’s series, not a special kind of line built into Excel. The chart legend usually gives each series a name, and its order commonly reflects the series order in the chart’s data source.

There is no universal rule that line 3 must be a particular color, value, or meaning. One workbook might use the third column of data for that line; another might use the third row. A chart may also have more series than are currently visible, or its source data may have been rearranged. The useful question is therefore: which series is being called line 3 in this particular chart?

Sometimes a reader means something else by “line 3.” They might mean the third horizontal gridline, the third point along a plotted line, or a line identified by an equation in a math graph. Those are different chart elements. The instructions here are for finding the third data series in an Excel chart.

How to Identify the Third Series

Start with the chart’s legend, if it has one. Legend entries identify plotted series, and the third entry is a reasonable first clue. For instance, if the legend lists North, Central, and South, the third series is likely South. This is a clue rather than proof: a chart may have been filtered, edited, or set up with a non-obvious series order.

To confirm the identity in Excel for Microsoft 365 on Windows:

  1. Click the chart to show the chart tabs on the ribbon.
  2. Choose Chart Design > Select Data.
  3. Look under Legend Entries (Series) in the Select Data Source dialog box.
  4. Select the third entry and choose Edit to inspect its series name and the cell range used for its values. Close the dialog without making changes if you only wanted to check it.

The series name may refer to a cell containing a heading, while the series values point to the cells containing the numbers. Check both. If a heading says South but the values range points to another store’s figures, the chart’s label or source range may need correction.

You can also select a line directly in the chart. Click the line once to select its series; Excel should identify the selected series in the ribbon’s Current Selection control on the Format tab. If points are close together or lines overlap, selecting by clicking can be difficult. In that case, use the Current Selection list or Select Data instead. Clicking a point after selecting a series can select an individual data point, which is different from selecting the whole line.

How Excel Builds Lines from Source Data

A chart series is a group of related values plotted together. In a typical line chart, the horizontal axis shows categories such as dates or months, and each series supplies one value for each category. A small table might have months in column A and the sales figures for three stores in columns B, C, and D. If Excel interprets each store column as a series, the figures in column D may make the third line.

That pattern is not guaranteed. If your categories and values are arranged in rows, Excel may instead treat rows as series. In the Select Data Source dialog, the Switch Row/Column control changes how Excel interprets the selected range. Use it only when the current chart has grouped the data incorrectly: switching can change which entries become separate lines and which labels appear on the horizontal axis.

Excel may also create a series name from a column or row heading. If there is no heading, the legend can show a generic label or an unhelpful name. A chart’s plotted order is separate from the meaning of the numbers: moving a series up or down does not change the underlying cell values, but it can change its order in the legend and how the lines are drawn relative to one another.

Change the Name or Order of Line 3

If you have confirmed which series is meant but its legend label is unclear, you can edit the series name. Open Chart Design > Select Data, select the relevant entry under Legend Entries (Series), and choose Edit. In the Series name field, enter a heading or select the worksheet cell that contains the desired name. Changing the chart’s series name does not rewrite the data in the cells.

To change the order, open the same dialog and select a series. Use the move-up or move-down controls beside the series list to reposition it, then confirm the change. The list order affects the legend and drawing order. If two lines overlap, changing the order may affect which one is easier to see, although it does not alter the data or make the values more accurate.

Before renaming or reordering a line in a shared report, check that the legend still agrees with the source data and any labels or explanations in the workbook. A clearer name is useful only if it accurately describes the values being plotted.

Format the Third Line

Once the correct series is selected, you can make it easier to distinguish without changing its values. Right-click the selected series and choose Format Data Series to open the formatting pane. The available line options depend on the chart type and selected element. For a standard line chart, you can adjust options such as line color, width, dash style, and markers.

Formatting is most useful when it improves comparisons. For example, a solid dark line with markers may stand out better than two pale, similarly styled lines. Keep the formatting consistent with the chart’s purpose, and do not rely on color alone if readers may have difficulty distinguishing colors. A different dash pattern or marker shape can help make series identifiable in print or for people with color-vision differences.

To format only one point rather than the complete line, select the series and then select the individual point. Be sure the selection indicator shows one data point before changing its appearance. Otherwise, a formatting change may apply to the entire series.

When “Line 3” Is Not a Data Series

Look at what the person asking about line 3 is pointing to. A horizontal gridline runs across the plot area and helps estimate values; it is not a data series and does not represent a separate set of measurements. Gridlines can be added or adjusted through Chart Design > Add Chart Element > Gridlines, with available choices depending on the chart and axis.

A third point is also different from the third line. Points are individual observations within a series. In a monthly chart, the third point might be March’s value, while the third series might represent a particular store across every month. If someone means the third point, identify the relevant series first, then inspect the point’s category and value.

In a scatter chart, each series consists of paired X and Y values, and the horizontal axis is numeric rather than a set of equally spaced categories. A plotted line may connect those points, but “line 3” still usually refers to a series if the chart contains several groups. Confirm the chart type and the data ranges before interpreting it as a third category or gridline.

Common Problems and Checks

If the third legend entry does not match the visible line you expected, check the chart’s source and settings before changing its appearance. These issues are common:

  • The legend is missing. Open Chart Design > Add Chart Element > Legend and choose a position, or use Select Data to inspect series names directly.
  • Two lines overlap. Select each series from the Current Selection list or the Select Data dialog. Different markers or line styles can help show which values belong to each series.
  • A series is not visible. Check whether its values are blank, outside the displayed range, hidden by another line, or filtered from the chart. A series can be present in the source list without being easy to see in the plot.
  • The line has the wrong label. Inspect the series name and values range in Select Data. A label can be correct-looking while pointing to the wrong cells.
  • The axis makes the line appear unusual. Check whether a series is plotted on a secondary axis and whether the axes use different scales. A line’s height is meaningful only in relation to the axis and scale shown.

For charts with many series, labels and colors alone may not be enough. Consider whether all the lines belong in one chart. Splitting unrelated measures into separate charts, or reducing the number of series shown at once, can make comparisons easier to understand.

Excel for Mac and Excel for the Web

In Excel for Microsoft 365 on Mac, the same basic approach applies: select the chart, use the chart design controls to open Select Data, and inspect the series list. Ribbon names and the placement of controls can differ slightly between Windows and Mac, so use the chart’s design or data-selection commands rather than relying on a Windows-only keyboard shortcut.

Excel for the web also supports chart editing, but some controls and formatting options may be arranged differently or be less complete than in the desktop app. If you cannot find a particular series-editing or formatting option in the browser, open the workbook in the desktop version of Excel. In all versions, the chart’s data source and series list are the reliable ways to confirm what a line represents.

Frequently Asked Questions

How do I find line 3 in an Excel chart?

Check the legend, then confirm the series order under Chart Design > Select Data. The third entry in Legend Entries (Series) is the third listed series, though the visible line can be hard to identify if series overlap or are hidden.

Does line 3 mean the third column in the worksheet?

Not necessarily. It may come from the third column if Excel treats columns as series, but a chart can use rows as series or reference non-adjacent ranges. Inspect the series name and values range in Select Data to see the actual source.

How can I make the third line easier to see?

Select the series through the chart or the Current Selection list, open Format Data Series, and change its line style, color, width, or markers. Choose a style that remains distinguishable when printed and does not imply a change to the data.

Why can’t I click the third line?

It may be covered by another line, too close to another series, or not visible because its values are blank or filtered. Select it from the chart’s series list instead of clicking the plot, then verify its name and cell range.

Is line 3 the same as the third gridline?

No. A data series connects values from a set of observations; a gridline is a visual reference across the chart’s plot area. If the question refers to a horizontal mark rather than a colored plotted series, it may mean a gridline instead.

Related

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.