Chart from more than 65000 lines

[Tim Grollman]

I have 100,000 rows of data that I want to display in a single chart. Is it possible to tweak the Data range in a way that will do this?

 

[KenWright]

Excel is limited to 65K rows, but if you have Access then you could dump it in there and then query it directly from Excel using Pivot Table/Chart functionality or MSQuery etc.