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!$A1:$B1',
values => '=Sheet1!$A2:$B2',
data_labels => { value => 1},
);
$chart->set_style( 18 );
$worksheet->insert_chart ('A4', $chart,0,0) ;
To be precise, there are two categories in '=Sheet1!$A1:$B1' viz. "Pass" & "Fail" & I want them to be green & red respectively in pie chart .