Line Chart data point limits

[randinator]

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

[6StringJazzer]

See this page

Data points in a data series for 2-D charts 32,000
Data points in a data series for 3-D charts 4,000
Data points for all data series in one chart 256,000

[LJMetzger]

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:

Sub CreateChartUsingModifiedChartWizardMacro()

    Charts.Add
    ActiveChart.ChartType = xlLine
    
    'The following line modified to generate the proper RANGE
    ActiveChart.SetSourceData Source:=Sheets("10JE002 GBL").Range("A1:B10408"), _
        PlotBy:=xlColumns
    ActiveChart.Location Where:=xlLocationAsObject, Name:="10JE002 GBL"
    With ActiveChart
        .HasTitle = True
        .ChartTitle.Characters.Text = "Water Level (m)"
        .Axes(xlCategory, xlPrimary).HasTitle = False
        .Axes(xlValue, xlPrimary).HasTitle = False
    End With
    
    'The following line added to delete the legend
    ActiveChart.Legend.Delete
    
End Sub

Lewis