Column - A writer class for Excel Column charts.
To create a simple Excel file with a Column chart using Spreadsheet::WriteExcel:
#!/usr/bin/perl -w use strict; use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new( 'chart.xls' ); my $worksheet = $workbook->add_worksheet(); my $chart = $workbook->add_chart( type => 'column' ); # Configure the chart. $chart->add_series( categories => '=Sheet1!$A$2:$A$7', values => '=Sheet1!$B$2:$B$7', ); # Add the data to the worksheet the chart refers to. my $data = [ [ 'Category', 2, 3, 4, 5, 6, 7 ], [ 'Value', 1, 4, 5, 2, 1, 5 ], ]; $worksheet->write( 'A1', $data ); __END__
This module implements Column charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook add_chart() method:
add_chart()
my $chart = $workbook->add_chart( type => 'column' );
Once the object is created it can be configured via the following methods that are common to all chart classes:
$chart->add_series(); $chart->set_x_axis(); $chart->set_y_axis(); $chart->set_title();
These methods are explained in detail in Spreadsheet::WriteExcel::Chart. Class specific methods or settings, if any, are explained below.
There aren't currently any column chart specific methods. See the TODO section of Spreadsheet::WriteExcel::Chart.
John McNamara jmcnamara@cpan.org
Copyright MM-MMX, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
To install Spreadsheet::WriteExcel, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Spreadsheet::WriteExcel
CPAN shell
perl -MCPAN -e shell install Spreadsheet::WriteExcel
For more information on module installation, please visit the detailed CPAN module installation guide.