Chart & Visualization Issues

Fix Excel 2016 for Mac Line Charts Showing Only One Series

Jason MillerJason Miller Nov 20, 2026 868 views

Question details

The user needs to troubleshoot an Excel 2016 for Mac line chart that displays only one of several yearly data series.

Fix Excel 2016 for Mac Line Charts Showing Only One Series
Product
Microsoft Excel 2016 for Mac
Device & OS
Mac
Scenario
A line chart is created from a data range containing multiple yearly series.
Observed behavior
The chart displays only one line even though the source data contains multiple series.
Before you start

Open the workbook and identify the cells containing the year labels and values for each series. If you plan to share screenshots, remove or obscure private information first.

Solution 1Recommended

Check the line chart data and series settings

Use the chart's data settings to check whether Excel recognizes each yearly series and how the data is arranged.

1
Inspect the source data

Select the worksheet cells used by the chart and check that each yearly series has a label and numeric values.

2
Open chart data settings

Click the chart, then choose Chart Design > Select Data. Check whether the selected range includes all yearly series and whether each series appears in the list.

3
Check the data orientation

In the chart data settings, try Switch Row/Column if Excel is treating the years or categories as the wrong series. Check whether the missing lines appear.

4
Compare the series values

Look at the values in the worksheet and the chart legend. Series with identical or very similar values can overlap, making multiple lines look like one.

If the settings look correct: The issue has also been reproduced in Excel 2016 for Mac. Gather the details below if the chart still shows only one line.
Free Microsoft Office alternative

Create Multi-Series Line Charts with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for opening spreadsheet files and creating charts. It can help you continue working with your data, although it does not repair Excel for Mac itself.

Create line charts from multiple data series in WPS Spreadsheet.Open and edit Microsoft Excel XLS and XLSX files.Use a familiar spreadsheet interface for a straightforward transition from Excel.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Where can I see which series are included in my Excel chart?

Click the chart and choose Chart Design > Select Data. Review the selected data range and the series listed in the dialog.

Why do several series look like a single line?

If series have identical or similar values, their lines can overlap. Compare the source values and check the chart legend to see which series Excel recognizes.

How do I find my Excel for Mac version?

Open Excel and choose Excel > About Excel. Record the version and build when describing the issue.

What should I include in a support request?

Include the Excel version, detailed reproduction steps, and screenshots of the selected data range, chart, and chart data settings. Remove private information before sharing.