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.
