I am trying to create a stacked chart reading data from a database. I dont understand how to display all the data. 
  
  
  
  
  
I have am testing it using one category which has three results (week 1, 20, 30, 40) 
  
  
  
I've changed <> with {} so that I could get it showing up properly. 
  
  
  
Do you have to loop through the database? 
  
  
  
  
  
sql string is - string strSQL =  "SELECT Student_kudos.points, Kudos.week, Kudos.Title FROM  Kudos INNER JOIN Student_kudos ON Kudos.KudosID = Student_kudos.KudosID WHERE (Student_kudos.studentID = 'xxxxxx') AND (Student_kudos.status = 'true')AND Kudos.week ='1'order by Kudos.week"; 
  
  
  
strXML.AppendFormat("{chart palette='1' caption='Weekly Kudos Breakdown' shownames='1' showvalues='0' numberPrefix='$' showSum='1'  decimals='0' overlapColumns='0'}"); 
  
         strXML.AppendFormat("{categories}{category label='week 1'/}{/categories}"); 
  
         strXML.AppendFormat("{dataset seriesName='1' showValues='0'}"); 
  
        strXML.AppendFormat("{set value='{0}'/}", oRs.ReadData["points"].ToString()); 
  
         strXML.AppendFormat("{set value='{0}'/}", oRs.ReadData["points"].ToString()); 
  
         strXML.AppendFormat("{set value='{0}'/}", oRs.ReadData["points"].ToString()); 
  
         strXML.AppendFormat("{/dataset}"); 
  
  
  
Thanks in advance