Does your db have a table where the date is the primary key?
No, the environment is the primary key; the dates are just field in the row.
I found that I can include extra fields in my query and then manipulate them to be what I want them to be before executing the cfchart. That solves some of the problems.
I think I need to step back and rethink the design. I used cfchartdata to test the display and found that it wasn't giving me the results they wanted.
After I figure something out, I'll post it here for everyone's amusement. Film at 11:00.
I finally found a way to do this.
The display is basically a 13-column table: the first column is the name and the subsequent columns are the months for the given year. Using the project dates and cfloop, I merely set the cell's background color if its project dates included the month and year of the cell. And to be really fancy, I assigned each project its own color.
And after all that, they decided that they really didn't need to see the display after all!
Management - what are you going to do with them?