"Undefined" - solution to MY issue
I used to have the same "undefined" issue when trying to display graphs with info pulled from SQL 2008.
When I opened up the charts_datax.asp file, and I checked the systax of my SQL query produced by Dynamic Web Charts, I realized that if my select statement is using a field that has spaces in the field name, I always get the "undefined" message instead of the plotted chart.
Take a look at the following syntax for a better understanding:
SELECT Publib records AS XLABEL, Count AS YVALUE FROM dbo.Members_by_public
In this case, "Publib records" is the name of the field.
Once I redefined my SELECT stamenet to
SELECT Publib_records AS XLABEL, Count AS YVALUE FROM dbo.Members_by_public
I was able to display the chart in no time.
In the SQL design, when you use square brackets around your field name with spaces [Publib records], the query works fine but when you incorporate this in your Dynamic Web Charts, the query will not retain the brackets, hence the error message.
Check the SELECT statement in the charts_datax.asp file.