debian man page for excel::writer::xlsx::chart::pie

Query: excel::writer::xlsx::chart::pie

OS: debian

Section: 3pm

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

Excel::Writer::XLSX::Chart::Pie(3pm)			User Contributed Perl Documentation		      Excel::Writer::XLSX::Chart::Pie(3pm)

NAME
Pie - A class for writing Excel Pie charts.
SYNOPSIS
To create a simple Excel file with a Pie chart using Excel::Writer::XLSX: #!/usr/bin/perl use strict; use warnings; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'chart.xlsx' ); my $worksheet = $workbook->add_worksheet(); my $chart = $workbook->add_chart( type => 'pie' ); # Configure the chart. $chart->add_series( categories => '=Sheet1!$A$2:$A$7', values => '=Sheet1!$B$2:$B$7', ); # Add the worksheet data 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__
DESCRIPTION
This module implements Pie charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method: my $chart = $workbook->add_chart( type => 'pie' ); 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_title(); These methods are explained in detail in Excel::Writer::XLSX::Chart. Class specific methods or settings, if any, are explained below. Pie Chart Methods There aren't currently any pie chart specific methods. See the TODO section of Excel::Writer::XLSX::Chart. A Pie chart doesn't have an X or Y axis so the following common chart methods are ignored. $chart->set_x_axis(); $chart->set_y_axis();
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart. #!/usr/bin/perl use strict; use warnings; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'chart_pie.xlsx' ); my $worksheet = $workbook->add_worksheet(); my $bold = $workbook->add_format( bold => 1 ); # Add the worksheet data that the charts will refer to. my $headings = [ 'Category', 'Values' ]; my $data = [ [ 'Apple', 'Cherry', 'Pecan' ], [ 60, 30, 10 ], ]; $worksheet->write( 'A1', $headings, $bold ); $worksheet->write( 'A2', $data ); # Create a new chart object. In this case an embedded chart. my $chart = $workbook->add_chart( type => 'pie', embedded => 1 ); # Configure the series. Note the use of the array ref to define ranges: # [ $sheetname, $row_start, $row_end, $col_start, $col_end ]. $chart->add_series( name => 'Pie sales data', categories => [ 'Sheet1', 1, 3, 0, 0 ], values => [ 'Sheet1', 1, 3, 1, 1 ], ); # Add a title. $chart->set_title( name => 'Popular Pie Types' ); # Set an Excel chart style. Colors with white outline and shadow. $chart->set_style( 10 ); # Insert the chart into the worksheet (with an offset). $worksheet->insert_chart( 'C2', $chart, 25, 10 ); __END__
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
Copyright MM-MMXII, 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. perl v5.10.1 2012-04-02 Excel::Writer::XLSX::Chart::Pie(3pm)
Related Man Pages
spreadsheet::writeexcel::chart::bar(3pm) - debian
excel::writer::xlsx::chart::scatter(3pm) - debian
spreadsheet::writeexcel::chart::pie(3pm) - debian
spreadsheet::writeexcel::chart::scatter(3pm) - debian
spreadsheet::writeexcel::chart::stock(3pm) - debian
Similar Topics in the Unix Linux Community
Automatic generate 3D pie Graph
Add more than 65536 rows to Excel
Support and Discussions for Tide Charts and Tide Tables
Run UNIX Script from Excel
Display Pie Chart/Bar Graph in microsoft outlook email using UNIX commands/Shell scripts