Spreatsheet:WriteExcel create Chart
- by yaohung
Hi,
I used
csv2xls.pl to convert a text log into .xls file, and then apply create chart function as following:
my $chart3 = $workbook-add_chart( type = 'line' , embedded = 1);
Configure the series.
$chart3-add_series(
categories = '=Sheet1!$B$2:$B$64',
values = '=Sheet1!$C$2:$C$64',
name = 'Test data series 1',
);
Add some labels.
$chart3-set_title( name = 'Bridge Rate Analysis' );
$chart3-set_x_axis( name = 'Packet Size ' );
$chart3-set_y_axis( name = 'BVI Rate' );
Insert the chart into the main worksheet.
$worksheet-insert_chart( 'G2', $chart3 );
==========
I can see the chart in .xls file, however, all the data is in text format, not number, therefore, the chart looks wrong.
I am wondering can you tell me how to convert text into number before apply this create chart function?
One other thing is any idea how to apply sorting on the .xls file before create chart?
Thanks.
Yaohung
