Fix Excel Combo Chart Data Ranges After Thousands of Points
Question details
The user needs an Excel combo chart to recognize both line series beyond approximately 6,844 data points.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A combo chart plots two line series from a large source data set.
- Observed behavior
- After approximately 6,844 points, the chart stops recognizing both data sets and displays an incorrect range.
Locate the worksheet columns containing the category labels and the two series, and identify the last populated row. Check whether the first row contains headers so it can be excluded from the plotted values.
Correct the combo chart's series and category ranges
Use explicit, matching ranges when the chart shows an incorrect source range.
Excel does not normally impose a 6,844-point limit on a chart series. A malformed reference or an unintended range may be responsible for the behavior.
Select the chart, then choose Chart Design > Select Data. Review the chart data range and the entries under Legend Entries (Series).
Select each series and click Edit. Replace any incorrect or full-column reference with an explicit range covering the data rows, such as 'Simple Data'!$B$2:$B$6845 for the first series and 'Simple Data'!$C$2:$C$6845 for the second.
Under Horizontal (Category) Axis Labels, click Edit and select the matching label range, such as 'Simple Data'!$A$2:$A$6845. Adjust the sheet name and row numbers to match your data.
Click OK to close the dialogs, then inspect the chart to confirm that both series extend through the intended last row.

Check source values and recreate the series
Use this approach if correcting the references does not restore both lines.
Plot Two Data Series in WPS Spreadsheets
Open the workbook in WPS Spreadsheets, check the source ranges, and create a chart for both data series. Use a combo chart if it is available in your version, or a line chart to plot both series.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Select the source data: On the source worksheet, select the category-label column and both value columns, including headers and all intended data rows.
- 3. Insert a chart: Choose Insert > Chart and select a combo chart if available. Otherwise, select a line chart to plot both series.
- 4. Check the plotted ranges: Select the chart and open its Select Data or data-range settings. Verify that both series and the category labels cover the intended rows.

Frequently Asked Questions
Does Excel limit a chart series to 6,844 points?
No. Excel does not normally have a 6,844-point series limit for a two-dimensional chart. Open Chart Design > Select Data and inspect the series and label references first.
Why does my chart show the wrong data range?
The chart may contain an unintended or malformed reference. Select the chart, choose Chart Design > Select Data, and edit each series and the horizontal axis labels to use the intended worksheet ranges.
Should I use full-column references for chart data?
Full-column references can include many empty cells. In Chart Design > Select Data, use explicit ranges that cover the populated rows, such as $B$2:$B$6845, to make the intended data easier to verify.
What if the chart range is correct but a line is still missing?
Check the source value cells for errors, blanks, or numbers stored as text. Then open Chart Design > Select Data and remove and add the affected series again if needed.




