Chart Question

[stanl]

Can a chart series point to a recordset from a SELECT Query. I am looking at an existing workbook where csv files are loaded then manually cut/paste into a worksheet to serve as a Vlookup for a chart series. If I can read the necessary data into a recordset via ADO, per chart requested, could that data serve as the series data. Does this make sense? Stan

[CBrine]

Stan,
I'm pretty sure its not possible to use the ADO recordset as the source for the vlookup, but it very easy to dump your recordset to a worksheet.

[VBA]
range("A1").copyfromrecordset
[/VBA]

Not sure if this is what you are looking for, but hopefully it helps.

Cal

[malik641]

I can't test this idea because I don't have MS Query on my desktop (grrrrr), but what about creating a pivot table using the CSV file as external data and edit the query in MS Query? You can make a Pivot chart off of that I think...


Otherwise, I'm not sure how you would do this.

[stanl]

I was thinking oRS.Getrows returns an array much like a Range Object Stan