msay Report post Posted February 7, 2010 (edited) I am using FC for Dreamweaver, my problem is when I create a Recordset with the following query I have NO Labels on my chart: SELECT SUM(opportunity.Jan_Amount), SUM(opportunity.Feb_Amount), SUM(opportunity.Mar_Amount), SUM(opportunity.Apr_Amount), SUM(opportunity.May_Amount),SUM(opportunity.Jun_Amount), SUM(opportunity.Jul_Amount),SUM(opportunity.Aug_Amount), SUM(opportunity.Sep_Amount), SUM(opportunity.Oct_Amount), SUM(opportunity.Nov_Amount), SUM(opportunity.Dec_Amount) FROM opportunity WHERE opportunity.Product_Service='Printers' This query totals the amounts in their respective columns; Jan_Amount Feb_Amount etc.. I have also tried the SELECT statement like this: SELECT SUM(opportunity.Jan_Amount) as Jan, SUM(opportunity.Feb_Amount) as Feb, etc.... My goal is to have each months total display as a series with corresponding labels. Thanks for any help! Edited February 7, 2010 by Guest Share this post Link to post Share on other sites