Hi Rajesh, On Fri, Sep 28, 2012 at 7:13 AM, Rajesh Saha <rajeshsaha...@gmail.com>wrote:
> 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 . > Please, see the module's author reply here: http://www.perlmonks.org/?node_id=996141 > The highlights of my script is as follows : > > ========================================= > use Excel::Writer::XLSX ; > ...... > ..... > > $chart->add_series( > categories => '=Sheet1!$C1:$D1', > values => '=Sheet1!$C1:$D$1', > data_labels => { value => 1 }, > ); > $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 > -- Tim
