PDA

View Full Version : Chart Question



stanl
03-09-2007, 03:13 PM
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
03-09-2007, 05:46 PM
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.


range("A1").copyfromrecordset


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

Cal

malik641
03-09-2007, 06:24 PM
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...:think:


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

stanl
03-10-2007, 04:55 AM
I was thinking oRS.Getrows returns an array much like a Range Object:think: Stan