my $workbook = Spreadsheet::WriteExcel->new("demo02.xls");
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart_ext('chart200.bin', 'Chart1');
$ worksheet->set_column('A:A', 20);
$workbook->add_format(color => 1);
$workbook->add_format(color => 2, bold => 1);
$workbook->add_format(color => 3);
my @data = (
And the result. Hurrah!
The chart was produced in Excel with some spurious data, extracted from Excel and then added to a Spreadsheet::WriteExcel file with new input data.
For now this is hackery and a little fragile but it is promising and surprising satisfying.