Generally you have to reconstruct the data into an appropriate format for a Flex chart, you can do that server-side or client-side before giving it to the chart.
John 2011/9/13 Brendan Meutzner <bmeutz...@gmail.com> > ** > > > I've re-read your post 3 times, and still can't make sense of how your data > is structured. > > Is there any way you can post an example of the structure? > > There's always a way to massage the data to fit into the charting... > > Brendan > > > On Mon, Sep 12, 2011 at 7:06 AM, chinwesley <wesleyc...@hotmail.com>wrote: > >> ** >> >> >> I want to create a line chart in Flex. I know how to create a simple one >> but the one I need to create needs to have 6 series (lines). >> >> The problem is that when I get the data from MYSQL, there is 6 xFields >> (one for each line) that are the same. eg. Western Cape - January, Western >> Cape - February, Western Cape - March, etc (for 6 months). >> >> That means that instead of there being only 9 xfields (province (south >> african provinces)), there is now 54 of them because they are being >> populated with all the values and not the unique ones. The same thing will >> happen with the line series becuase the line series will have 6 of the >> January's, 6 of the February's and so on. >> >> I just want to have 9 xfields and not 54 and 6 months and not 9 of each. >> >> Is there a way to solve this please? >> >> Regards, >> Wesley >> >> > >