> 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:332937
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
