Fix Excel 2016 for Mac Line Charts Showing Only One Series
Question details
The user needs to troubleshoot an Excel 2016 for Mac line chart that displays only one of several yearly data 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.
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.
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.
Select the worksheet cells used by the chart and check that each yearly series has a label and numeric values.
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.
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.
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.
Update Office and collect troubleshooting details
Use this approach if checking the data and chart settings does not explain the missing series.
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.

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.




