Excel::Writer::XLSX - pie chart legend's color

rajeshsaha123 has asked for the wisdom of the Perl Monks concerning the following question:

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) ;
[download]

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 .

Comment on Excel::Writer::XLSX - pie chart legend's color Download Code

Replies are listed 'Best First'.
Re: Excel::Writer::XLSX - pie chart legend's color by jmcnamara (Monsignor) on Sep 28, 2012 at 08:48 UTC
It is possible to define chart colors for most types of Excel::Writer::XLSX charts via the `add_series()` method. However, Pie charts in Excel are a special case since each pie segment is actually a point and there isn't currently any way in Excel::Writer::XLSX to define colors for individual points. The `set_style()` method, which you are using, is currently the only way of changing Pie chart colours. -- John.	[reply] [d/l]
Re: Excel::Writer::XLSX - pie chart legend's color by ckj (Chaplain) on Sep 28, 2012 at 07:50 UTC
Well you can easily find solution for this from http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.51/lib/Excel/Writer/XLSX/Examples.pm and also for reading and writing records to excel file I think http://search.cpan.org/dist/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pmis the most appropriate. Please let me know if you've any confusion in understanding from this these links. For reference , please follow this exact link : http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.51/lib/Excel/Writer/XLSX/Examples.pm#Example:_colors.pl	[reply]
Re: Excel::Writer::XLSX - pie chart legend's color by rajeshsaha123 (Initiate) on Sep 28, 2012 at 11:21 UTC
@john Thanks for the explanation. Do you have any plan to implement this in near future ? Rajesh	[reply]
Re^2: Excel::Writer::XLSX - pie chart legend's color by Anonymous Monk on Sep 28, 2012 at 11:33 UTC
Hi, perlmonks has threaded discussions :), no need for this @at stuff, just click the reply link on the post you wish to reply to	[reply]


No such thing as a small change
	PerlMonks