You should be able to accomplish what you're looking for just by adding 3 data series to the chart you're building. The most straightforward way to do it would probably be to modify your stored procedure to take another input parameter called "status" so you could view the results for a particular status type. Then drop all 3 sets of results into the chart as their own series. The attribute for CFCHART you'll want to play around with is "seriesPlacement" which can have values of "default, cluster, stacked, percent." That will control how the different data points get displayed.
Good luck! -Cliff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
