Limit to data points in a combo chart?

Copper Contributor

I want a combo chart set up as two line graphs on two columns of data e.g.  ='Simple Data'!$A$2:$B$500.  This is working.

However, when I go over 6844 data points, the chart stops recognizing two sets of data and complains that I only have one. Furthermore, the selected data sets show up on the sheet as the last row of column A and all of column A. 

Is there some inherent limit to the number of data points that can be charted?

0 Replies