Line Chart data point limits

Hi there. Does anyone know if Excel 2010 has a limit on the number of data points that can be plotted on a single graph? I'm trying to plot time-series data (daily values) for several years, and I know I've been able to do this before.........

I've attached the spreadsheet data if anyone can figure this out.

Thanks

Rando

Hi randinator,

In my copy of Excel 2003, the Chart Wizard got confused by missing data points and started to plot at row 8978 (in 2009). I modified the Macro created by the Chart Wizard when the Macro recorder was on to:
a. Give the proper range of data points 'A1:B10408'
b. Delete the Legend (which also seemed to be confused)

Macro code follows that plots all the data points:

Please Login or Register  to view this content.

Lewis