as i said, i haven't played with dynamic webcharts, so dont know if this will help.
However, to extract the month number from a date field, in your mySQL select statement, add the following...
MONTH(datefield) AS monthnumber
where datefield is the field in your table and monthnumber is just the alias you want to use for the result.
This will return an integer between 1 and 12