Creating geographical charts with EuroOffice Map Chart

3 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Geographical distance between long and lat in bash

Does anyone know of any script or packages that allow the calculation of the geographical distance between two points of lat/long from within a bash shell? I have been searching the web for the past few days and none of the options seem compatible with bash variables... (eg. geodist) Many...

2. Shell Programming and Scripting

Geographical location details of a server

Is there a way to find geographical location details of a server in shell scripting ? Say, which region server is located at etc.

3. Shell Programming and Scripting

Find the geographical location within a shell script

Hi, I need a shell script that when run should be able to find the geographical location of the system. can anyone help me with this? Thanks, Sundeep

LEARN ABOUT DEBIAN

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

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)

UNIX and Linux RSS News