Hi i am tryng to place multiple charts in a singe excel sheet, but all the charts are overlapping on each other. Here is the code i am using.

$chart_one = [[ "Passed","100"],["Fail","20"]
];
$chart_two =[[ "Passed","80"],["Fail","30"]
$chart_three =[[ "Passed","60"],["Fail","70"]

$range_of_data_one = wb->ActiveSheet->Range("A2:B3");
$range_of_data_one->{Value} = $chart_one; 

$range_of_data_two = wb->ActiveSheet->Range("D2:E3");    
$range_of_data_two->{Value} = $chart_two;     

$range_of_data_three = wb->ActiveSheet->Range("G2:H3");    
$range_of_data_three->{Value} = $chart_three;

        
$chart = wb->Charts->Add;
$chart->SetSourceData($range_of_data_one, 2);
$chart->{ChartType} = 70;
$chart->Location(xlLocationAsObject, "Sheet 2");    


$chart = wb->Charts->Add;

$chart->SetSourceData($range_of_data_two, 2);
$chart->{ChartType} = 70;
$chart->Location( xlLocationAsObject, 'Sheet 2' );


$chart = wb->Charts->Add;
$chart->SetSourceData($range_of_data_three, 2);
$chart->{ChartType} = 70;
$chart->Location( xlLocationAsObject, 'Sheet 2' );
[download]

Can you please help us in giving title to pie charts using Win32 ole