Thanks ofr the suggestion. Ray Camden helped me on this one, and ended up
blogging about it. Here's the link to Ray's blog post on it:
http://www.coldfusionjedi.com/index.cfm/2010/3/12/Coloring-CFCHART-Dynamically
> > The cfChartSeries attribute colorlist will allow a series
> > of colors, but in this case the X axis is ordered by
> > department name rather than by response percentage.
>
> Just sifting through a ton of old mailing list items ..
>
> I am sure you figured this out already. But for the archives, you
> could calculate the colorlist dynamically. A simple approach is using
> a CASE statement in your db query to determine the colors for each
> value.
>
> SELECT Department, ResponseValue,
> CASE
> WHEN ResponseValue BETWEEN 0 AND 49 THEN 'Red' -- in hex ...
> WHEN ResponseValue BETWEEN 50 AND 74 THEN 'Orange'
...
> etc...
> END AS BarColor
>
...
> or store the color range information in a db table and use a JOIN.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
