新聞財經娛樂♬資訊 News Economy

I have 55000 data and need to be plotted  in one curve within one plot.
But in excel, it report out just show or allow the limit  32000 data in my chart I created.
Now Can I solve it in Excel 2003 by VBA ?
I try this following VBA code  before, but it is not working, just show me two sepearte curves only, how to combine two into one curve with
correct X-axis value ? OR I also need to seperate the x -axis data into two series and combine it one
by vba code ?
Please advise

Duncan

Sub Chart()
'Plot Y-axis data from two separate series into one
Dim firstrow as long
Dim lastrow as long
Dim seclastrow as long
firstrow=1
lastrow=20000
seclastrow=55000
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection.NewSeries  'need to be delete if create is done
ActiveChart.SeriesCollection(1).Values = "=" & sheetname & "!R" & firstrow & "C8:R" & lastrow & "C8"
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(2).Values = "=" & sheetname & "!R" & lastrow+1 & "C8:R" & seclastrow & "C8"
End Sub

Hello,

In Excel 2003, the limit for data points in a 2D chart is 32,000. In Excel 2010, the limit is determined by the available memory.


In any case, a chart with more than 32,000 data points will make it impossible to identify an individual data point. The rendered chart would have to be a mile wide to make individual data points distinguishable. So, what's the point of trying to include more than 32,000 data points, if they will not be distinguishable in the first place?

Have you considered creating an aggregation of the data and not plot EVERY data point, but ever nth point instead (like every 10th value, or every 100th value)?

cheers,  teylyn