0 Replies Latest reply on Oct 6, 2009 11:47 AM by StreetChariot

    Using 2 column DataGrid to populate Charts?

    StreetChariot

      Here is my delima.... I am developing dashboards for a company that refuses to use XML. I've been able to get the data from their CSV files into both DataGrids and the Spedo's.  I am however unable to pull the data from DataGrid to create a pie chart.
      Here is the contents of the CSV file (which is populated into the DataGrid). First row is the header.

       

      ITEM,TOTAL
      HWH,12
      STAT,14
      LFSH,6
      WI,7
      PW,3
      


      How do I go about getting this data into a chart? I assumed that since I had already spent the time getting the data into a datagrid that I could pull it out of the DataGrid and into the chart, but I have not been able to figure out how to do that.

       

      Here is the code for my DataGrid also, if it matters:

      <mx:DataGrid
      
       x="0" y="0" id="measures" width="301" height="200" maxHeight="200" maxWidth="628" minHeight="200" minWidth="628" color="#000000">
      
      
      <mx:columns>
      
      
      <mx:DataGridColumn headerText="Measure" id="MSRE" dataField="col4"/>
      
      
      <mx:DataGridColumn headerText="Total" id="TTL" sortDescending="false" dataField="col5"/>
      
      
      </mx:columns>
      
      
      </mx:DataGrid>
      
      
      
      

       

      The col4 and col5 get their data from the parser for CSV.

       

       

      Thanks in advance for any help you can give me.