excel graph

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

Hi, I am creating a graph in excel using perl. Below is the link, I used to refer for creating the chart :- http://search.cpan.org/dist/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel/Chart.pm#Chart_line_weights I am able to create the column chart. But now, I want to change the color of bar that are occuring in the chart. I tried:-

 
     $chart->add_series (
          categories => x1_range_formula ('Sheet1',1,9,0,0),
          values       => x1_range_formula ('Sheet1',1,9,1,1),
          name        => 'TEST',
          color         => 'green,'
      );
[download]

This color part is not changing the color in the bars. Default color is occurring in the bars. What shall I do to change the color and width of bars?? Regards

Comment on excel graph Download Code

Replies are listed 'Best First'.
Re: excel graph by zentara (Cardinal) on Sep 12, 2011 at 09:19 UTC
There may be some clues for you in ParseExcel - need background color info I'm not really a human, but I play one on earth. Old Perl Programmer Haiku ................... flash japh	[reply]
Re^2: excel graph by tarunkhanna (Novice) on Sep 12, 2011 at 11:55 UTC
No...This doesn't contain the required information.	[reply]
Re: excel graph by jmcnamara (Monsignor) on Sep 12, 2011 at 16:29 UTC
You can't change the series line or fill colours in a graph with Spreadsheet::WriteExcel. You can do it with Excel::Writer::XLSX which is (more or less) a drop in replacement for Spreadsheet::WriteExcel. -- John.	[reply]
Re: excel graph by Anonymous Monk on Sep 12, 2011 at 06:57 UTC
And where do you see add_series taking a color argument?	[reply]
Re^2: excel graph by tarunkhanna (Novice) on Sep 12, 2011 at 07:41 UTC
ok..so, how to change the color of bar in graph?? My main motive is to change the color of bar. Regards.	[reply]
Re^3: excel graph by Corion (Patriarch) on Sep 12, 2011 at 07:48 UTC
Please look again at Spreadsheet::WriteExcel::Chart, especially the section Chart object colours.	[reply]
Re^4: excel graph by tarunkhanna (Novice) on Sep 12, 2011 at 08:54 UTC
Re^5: excel graph by Corion (Patriarch) on Sep 12, 2011 at 08:59 UTC
Re^5: excel graph by davies (Monsignor) on Sep 12, 2011 at 11:53 UTC