Fusionchart category and product wise pie chart and barchart

Hello Guys,

i am working on fusion charts i wanted to show category and product wise chart but i am not getting any solution for that now i am getting category with all products with different category

i wanted to show like

category 1 with product1,product2

category 2 with product3,product4

category 3 with product5,product6

if anyone can help me out

action code


Yii::app ()->fusioncharts->setChartOptions ( array ('caption' => 'Total Projects', 'xAxisName' => 'Product Groups', 'yAxisName' => 'Products' ) );

				Yii::app()->fusioncharts->addCategory(array('label'=>'Cat1'));

				Yii::app()->fusioncharts->addCategory(array('label'=>'Cat2'));

					

				$options = array('seriesName' => 'Series1'); // must specify series anme

				Yii::app()->fusioncharts->addDataSet('data_unique_key', $options);

				$options = array('seriesName' => 'Series2'); // must specify series anme

				Yii::app()->fusioncharts->addDataSet('data_unique_key2', $options);

				

				

				$options = array('value' => 1);

				Yii::app()->fusioncharts->addSetToDataSet('data_unique_key', $options);

				$options = array('value' => 2);

				Yii::app()->fusioncharts->addSetToDataSet('data_unique_key', $options);

				

				$options = array('value' => 3);

				Yii::app()->fusioncharts->addSetToDataSet('data_unique_key2', $options);

				$options = array('value' => 4);

				Yii::app()->fusioncharts->addSetToDataSet('data_unique_key2', $options);

					

							

                // Add two data sets

                //Yii::app ()->fusioncharts->addDataSet ( 'data_unique_key', $options );

                //Yii::app ()->fusioncharts->addDataSet ( 'data_unique_key2', $options );

        

//                Yii::app ()->fusioncharts->addTrendLine ( array ('startValue' => '1000', 'color' => '009933', 'displayvalue' => 'Target' ) );

                Yii::app ()->fusioncharts->addDefinition ( array ('name' => 'CanvasAnim', 'type' => 'animation', 'param' => '_xScale', 'start' => '0', 'duration' => '1' ) );

                Yii::app ()->fusioncharts->addApplication ( array ('toObject' => 'Canvas', 'styles' => 'CanvasAnim' ) );

                      

				

				var_dump(Yii::app()->fusioncharts->getXMLData(true));

				

				Yii::app ()->fusioncharts->useI18N = true;

view page code


<?php $this->widget('ext.fusioncharts.fusionChartsWidget', array( 

                              'chartType'=>'MSColumn2D','chartNoCache'=>true, // disabling chart cache

                              'chartAction'=>Yii::app()->urlManager->createUrl('/members/reports/chart'), // the chart action that we just generated the xml data at

							  'chartId'=>'course_load')); // If you display more then one chart on a single page then make sure you specify and id                 

?>