echajoa/vendor/phpoffice/phppresentation/samples/Sample_05_Chart_with_PHPExcel.php

<?php

include_once 'Sample_Header.php';

use PhpOffice\PhpPresentation\PhpPresentation;
use PhpOffice\PhpPresentation\Shape\Chart\Type\Bar3D;
use PhpOffice\PhpPresentation\Shape\Chart\Type\Pie3D;
use PhpOffice\PhpPresentation\Shape\Chart\Series;
use PhpOffice\PhpPresentation\Style\Fill;
use PhpOffice\PhpPresentation\Style\Color;
use PhpOffice\PhpPresentation\Style\Border;

if (!class_exists('PHPExcel')) {
	echo('<strong>PHPExcel has not been loaded. Include PHPExcel.php in your script, e.g. require_once \'PHPExcel.php\'.</strong>');
} else {
	// Create new PHPPresentation object
	echo date('H:i:s') . ' Create new PHPPresentation object'.EOL;
	$objPHPPresentation = new PhpPresentation();
	
	// Set properties
	echo date('H:i:s') . ' Set properties'.EOL;
	$objPHPPresentation->getDocumentProperties()->setCreator('PHPOffice')
										->setLastModifiedBy('PHPPresentation Team')
										->setTitle('Sample 08 Title')
										->setSubject('Sample 08 Subject')
										->setDescription('Sample 08 Description')
										->setKeywords('office 2007 openxml libreoffice odt php')
										->setCategory('Sample Category');
	
	// Remove first slide
	echo date('H:i:s') . ' Remove first slide'.EOL;
	$objPHPPresentation->removeSlideByIndex(0);
	
	// Create templated slide
	echo date('H:i:s') . ' Create templated slide'.EOL;
	$currentSlide = createTemplatedSlide($objPHPPresentation); // local function
	
	// Generate sample data for first chart
	echo date('H:i:s') . ' Generate sample data for first chart'.EOL;
	$series1Data = array('Jan' => 133, 'Feb' => 99, 'Mar' => 191, 'Apr' => 205, 'May' => 167, 'Jun' => 201, 'Jul' => 240, 'Aug' => 226, 'Sep' => 255, 'Oct' => 264, 'Nov' => 283, 'Dec' => 293);
	$series2Data = array('Jan' => 266, 'Feb' => 198, 'Mar' => 271, 'Apr' => 305, 'May' => 267, 'Jun' => 301, 'Jul' => 340, 'Aug' => 326, 'Sep' => 344, 'Oct' => 364, 'Nov' => 383, 'Dec' => 379);
	
	// Create a bar chart (that should be inserted in a shape)
	echo date('H:i:s') . ' Create a bar chart (that should be inserted in a chart shape)'.EOL;
	$bar3DChart = new Bar3D();
	$bar3DChart->addSeries( new Series('2009', $series1Data) );
	$bar3DChart->addSeries( new Series('2010', $series2Data) );
	
	// Create a shape (chart)
	echo date('H:i:s') . ' Create a shape (chart)'.EOL;
	$shape = $currentSlide->createChartShape();
	$shape->setName('PHPPresentation Monthly Downloads')
			->setResizeProportional(false)
			->setHeight(550)
			->setWidth(700)
			->setOffsetX(120)
			->setOffsetY(80)
			->setIncludeSpreadsheet(true);
	$shape->getShadow()->setVisible(true)
			->setDirection(45)
			->setDistance(10);
	$shape->getFill()->setFillType(Fill::FILL_GRADIENT_LINEAR)
						->setStartColor(new Color('FFCCCCCC'))
						->setEndColor(new Color('FFFFFFFF'))
						->setRotation(270);
	$shape->getBorder()->setLineStyle(Border::LINE_SINGLE);
	$shape->getTitle()->setText('PHPPresentation Monthly Downloads');
	$shape->getTitle()->getFont()->setItalic(true);
	$shape->getPlotArea()->getAxisX()->setTitle('Month');
	$shape->getPlotArea()->getAxisY()->setTitle('Downloads');
	$shape->getPlotArea()->setType($bar3DChart);
	$shape->getView3D()->setRightAngleAxes(true);
	$shape->getView3D()->setRotationX(20);
	$shape->getView3D()->setRotationY(20);
	$shape->getLegend()->getBorder()->setLineStyle(Border::LINE_SINGLE);
	$shape->getLegend()->getFont()->setItalic(true);
	
	// Create templated slide
	echo date('H:i:s') . ' Create templated slide'.EOL;
	$currentSlide = createTemplatedSlide($objPHPPresentation); // local function
	
	// Generate sample data for second chart
	echo date('H:i:s') . ' Generate sample data for second chart'.EOL;
	$seriesData = array('Monday' => 12, 'Tuesday' => 15, 'Wednesday' => 13, 'Thursday' => 17, 'Friday' => 14, 'Saturday' => 9, 'Sunday' => 7);
	
	// Create a pie chart (that should be inserted in a shape)
	echo date('H:i:s') . ' Create a pie chart (that should be inserted in a chart shape)'.EOL;
	$pie3DChart = new Pie3D();
	$pie3DChart->addSeries( new Series('Downloads', $seriesData) );
	
	// Create a shape (chart)
	echo date('H:i:s') . ' Create a shape (chart)'.EOL;
	$shape = $currentSlide->createChartShape();
	$shape->setName('PHPPresentation Daily Downloads')
			->setResizeProportional(false)
			->setHeight(550)
			->setWidth(700)
			->setOffsetX(120)
			->setOffsetY(80)
			->setIncludeSpreadsheet(true);
	$shape->getShadow()->setVisible(true)
						->setDirection(45)
						->setDistance(10);
	$shape->getFill()->setFillType(Fill::FILL_GRADIENT_LINEAR)
						->setStartColor(new Color('FFCCCCCC'))
						->setEndColor(new Color('FFFFFFFF'))
						->setRotation(270);
	$shape->getBorder()->setLineStyle(Border::LINE_SINGLE);
	$shape->getTitle()->setText('PHPPresentation Daily Downloads');
	$shape->getTitle()->getFont()->setItalic(true);
	$shape->getPlotArea()->setType($pie3DChart);
	$shape->getView3D()->setRotationX(30);
	$shape->getView3D()->setPerspective(30);
	$shape->getLegend()->getBorder()->setLineStyle(Border::LINE_SINGLE);
	$shape->getLegend()->getFont()->setItalic(true);
	
	// Save file
	echo write($objPHPPresentation, basename(__FILE__, '.php'), $writers);
}
if (!CLI) {
	include_once 'Sample_Footer.php';
}