Re^2: excel graph

Replies are listed 'Best First'.
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
Hey, `$chart->set_plotarea( color => 'red' );` will change the background color chart. i don't want this color to be changed. I want the color of bars in column chart or color of lines in line chart to be changed. The link you gave me doesn't contain the information I am asking for. Regards.	[reply] [d/l]
Re^5: excel graph by Corion (Patriarch) on Sep 12, 2011 at 08:59 UTC
Sorry - looking again at Spreadsheet::WriteExcel::Chart, it lists under the TODO section that Colours and formatting options. For now you will have to make do with the default Excel colours and formats. This means changing the colors and formatting of series is unlikely to work yet.	[reply]
Re^5: excel graph by davies (Monsignor) on Sep 12, 2011 at 11:53 UTC
If you're running on a machine with Excel, you can automate anything that Excel can do, including changing chart colours with Win32::OLE. Microsoft's example More information from a monk A recent thread on chart colours Regards, John Davies	[reply]