Im attempting a couple things so i have a coule questions 1 IS it possible to do an IIF inside the Series color? I have a chart that is a bar chart shoing children who recieved inqueries and id like to color their bars pink/blue based on gender.
2. How do i get the labels to show for EVERY item in the list. right now its showing every 10th im assuming because of lineheight. but even changing font size to 6 point i get every 4th one. Any Thoughts? here is what i get with the fololowing code http://www.webintegrity.us/GraphData.jpg <cfquery name="ParentSums" datasource="#DSN#" username="#dbusername#" password="#dbpassword#"> SELECT COUNT(Correspondence.CorrespondenceChildID) AS callcount, Correspondence.CorrespondenceChildID, tbl_Children.CHILD_ID, tbl_Children.FIRSTNAME, tbl_Children.SEX FROM Correspondence LEFT OUTER JOIN tbl_Children ON Correspondence.CorrespondenceChildID = tbl_Children.REC_ID WHERE (Correspondence.CorrespondenceDate >= <cfqueryparam value="#Startdate#" cfsqltype="CF_SQL_DATE" />) AND ( Correspondence.CorrespondenceDate <= <cfqueryparam value="#Enddate#" cfsqltype="CF_SQL_DATE" />) AND (Correspondence.CorrespondenceChildID IS NOT NULL) GROUP BY Correspondence.CorrespondenceChildID, tbl_Children.CHILD_ID, tbl_Children.FIRSTNAME, tbl_Children.SEX ORDER BY Correspondence.CorrespondenceChildID </cfquery> <cfchart format="flash" chartheight="1000" chartwidth="500" showxgridlines="no" showygridlines="no" showborder="no" fontbold="no" fontitalic="no" labelformat="number" show3d="yes" rotated="no" sortxaxis="yes" showlegend="yes" tipstyle="MouseOver" tipbgcolor="##CCCCCC" showmarkers="no" style="default" backgroundcolor = "##37b2fb" > <cfchartseries type="horizontalbar" query="ParentSums" itemcolumn="CHILD_ID" valuecolumn="callcount" serieslabel="CHILD_ID" seriescolor="#IIF(SEX is 'Female', de('red'), de('blue'))#" paintstyle="raise" /> </cfchart> DATA Jan 01, 2005 *Through* Feb 01, 2005 Child ID Name Inqueries 1770B Mia 1 3103 Robert 1 3229 Trevia 1 3354A Precious 6 3354B Judas 1 3360 Randy 3 3404A Damar 3 3411A Keontaye 3 3030 Kyle 2 3429A Sarah 1 3442 Shawn 5 3466 Michael 2 3482 Chris 1 3489 Craig 2 3494 Keith 1 3496 Christopher 2 3498 Teleatha 2 3503 Dartangan 1 3507A Garrett 7 3510 Manny 16 3516 Nicole 3 3518 Jessica 5 3519 Christopher 3 3522D Isaac 1 3524B Jose 1 3525 Katrina 1 3527A Susie 3 3530 Jason 1 3531A Lukas 3 3531B Vincent 1 3534 Dana 1 3535A Monea 1 3535C Michelle 2 3537 Maxwell 1 3538 Adam 1 3539A Dezaraye 11 3539B Samantha 1 3541A Anita 19 3541B Mauda 7 3541C Rosa 2 3541D Oscar 2 3078 Trevor 3 3395 Melissa 6 3397 Johnathan 1 3420 Brea 1 3450A Gininia 1 3522B Shena 1 3532 Kenny 5 Grand Total 149 -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 "...the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
