Hi,
I am trying to create one excel file, where chart will be included.
Though, I am able to create this, but I could not customise the colors of
the individual legends within th pie chart.
Can anybody give an idea , please .
The highlights of my script is as follows :
=========================================
use Excel::Writer::XLSX ;
......
.....
my $p = $chart->add_series(
categories => '=Sheet1!$C1:$D1',
values => '=Sheet1!$C5:$D$5',
data_labels => { value => 1,percentage => 1},
);
$chart->set_title(name => 'Test case Result') ;
$chart->set_style( 18 );
$worksheet->insert_chart ('A4', $chart,0,0) ;
=============================================
To be precise, there are two categories in '=Sheet1!$C1:$D1' viz. "Pass" &
"Fail" & I want them to be green & red respectively in pie chart .
Thanks and regards,
Rajesh Saha
