Convert Grid data to a chart

[AidanGuy]

I have a grid which is populated from an SQL database, it has a search box which when populated filters the results.
I am trying to output the filtered results in charts. I currently have all the SQL data output in charts but would like to make them dynamic to match what the grid is displaying.
Any help would be much appreciated

[mat_evans]

I have something that might help. I have a grid that I use a CFC to populate, but then I also need to export the data to excel and CSV. I do this by setting a session variable just before the result get passed back from the CFC. This variable contains the query that has provided the data, so i can then use it to create the files I need for the export.

It might help in your situation.

Cheers,