Yu1709$!%yuyu!$%wutu!5=126+

                
____  ___       .__                 
\   \/  /  _____|  |   ______  _  __
 \     /  /  ___/  |  /  _ \ \/ \/ /
 /     \  \___ \|  |_(  <_> )     / 
/___/\  \/____  >____/\____/ \/\_/  
      \_/     \/    @ligmakokz

Editing: 33chartcreate-bar.php

<?php

/** Error reporting */
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');

define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');

date_default_timezone_set('Europe/London');

/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2015 PHPExcel
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * @category   PHPExcel
 * @package    PHPExcel
 * @copyright  Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
 * @version    ##VERSION##, ##DATE##
 */

/** PHPExcel */
require_once dirname(__FILE__) . '/../Classes/PHPExcel.php';

$objPHPExcel = new PHPExcel();
$objWorksheet = $objPHPExcel->getActiveSheet();
$objWorksheet->fromArray(
	array(
		array('',	2010,	2011,	2012),
		array('Q1',   12,   15,		21),
		array('Q2',   56,   73,		86),
		array('Q3',   52,   61,		69),
		array('Q4',   30,   32,		0),
	)
);

//	Set the Labels for each data series we want to plot
//		Datatype
//		Cell reference for data
//		Format Code
//		Number of datapoints in series
//		Data values
//		Data Marker
$dataSeriesLabels = array(
	new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
	new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
	new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
);
//	Set the X-Axis Labels
//		Datatype
//		Cell reference for data
//		Format Code
//		Number of datapoints in series
//		Data values
//		Data Marker
$xAxisTickValues = array(
	new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
);
//	Set the Data values for each data series we want to plot
//		Datatype
//		Cell reference for data
//		Format Code
//		Number of datapoints in series
//		Data values
//		Data Marker
$dataSeriesValues = array(
	new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
	new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
	new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
);

//	Build the dataseries
$series = new PHPExcel_Chart_DataSeries(
	PHPExcel_Chart_DataSeries::TYPE_BARCHART,		// plotType
	PHPExcel_Chart_DataSeries::GROUPING_CLUSTERED,	// plotGrouping
	range(0, count($dataSeriesValues)-1),			// plotOrder
	$dataSeriesLabels,								// plotLabel
	$xAxisTickValues,								// plotCategory
	$dataSeriesValues								// plotValues
);
//	Set additional dataseries parameters
//		Make it a horizontal bar rather than a vertical column graph
$series->setPlotDirection(PHPExcel_Chart_DataSeries::DIRECTION_BAR);

//	Set the series in the plot area
$plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series));
//	Set the chart legend
$legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false);

$title = new PHPExcel_Chart_Title('Test Bar Chart');
$yAxisLabel = new PHPExcel_Chart_Title('Value ($k)');

//	Create the chart
$chart = new PHPExcel_Chart(
	'chart1',		// name
	$title,			// title
	$legend,		// legend
	$plotArea,		// plotArea
	true,			// plotVisibleOnly
	0,				// displayBlanksAs
	NULL,			// xAxisLabel
	$yAxisLabel		// yAxisLabel
);

//	Set the position where the chart should appear in the worksheet
$chart->setTopLeftPosition('A7');
$chart->setBottomRightPosition('H20');

//	Add the chart to the worksheet
$objWorksheet->addChart($chart);

// Save Excel 2007 file
echo date('H:i:s') , " Write to Excel2007 format" , EOL;
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->setIncludeCharts(TRUE);
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;

// Echo memory peak usage
echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;

// Echo done
echo date('H:i:s') , " Done writing file" , EOL;
echo 'File has been created in ' , getcwd() , EOL;

Name	Type	Actions
data	Directory
images	Directory
templates	Directory
.gitignore	File
01pharSimple.php	File
01simple-download-ods.php	File
01simple-download-pdf.php	File
01simple-download-xls.php	File
01simple-download-xlsx.php	File
01simple.php	File
01simple.xls	File
01simple.xlsx	File
01simplePCLZip.php	File
01simplePCLZip.xlsx	File
02types-xls.php	File
02types-xls.xls	File
02types.php	File
02types.xlsx	File
03formulas.php	File
03formulas.xls	File
03formulas.xlsx	File
04printing.php	File
04printing.xls	File
04printing.xlsx	File
05featuredemo.inc.php	File
05featuredemo.php	File
05featuredemo.xls	File
05featuredemo.xlsx	File
06largescale-with-cellcaching-sqlite.php	File
06largescale-with-cellcaching-sqlite.xlsx	File
06largescale-with-cellcaching-sqlite3.php	File
06largescale-with-cellcaching-sqlite3.xlsx	File
06largescale-with-cellcaching.php	File
06largescale-with-cellcaching.xlsx	File
06largescale-xls.php	File
06largescale-xls.xls	File
06largescale.php	File
06largescale.xlsx	File
07reader.php	File
07reader.xlsx	File
07readerPCLZip.php	File
07readerPCLZip.xlsx	File
08conditionalformatting.php	File
08conditionalformatting.xls	File
08conditionalformatting.xlsx	File
08conditionalformatting2.php	File
08conditionalformatting2.xls	File
08conditionalformatting2.xlsx	File
09pagebreaks.php	File
09pagebreaks.xls	File
09pagebreaks.xlsx	File
10autofilter-selection-1.php	File
10autofilter-selection-1.xls	File
10autofilter-selection-1.xlsx	File
10autofilter-selection-2.php	File
10autofilter-selection-2.xls	File
10autofilter-selection-2.xlsx	File
10autofilter-selection-display.php	File
10autofilter.php	File
10autofilter.xls	File
10autofilter.xlsx	File
11documentsecurity-xls.php	File
11documentsecurity-xls.xls	File
11documentsecurity.php	File
11documentsecurity.xlsx	File
12cellProtection.php	File
12cellProtection.xlsx	File
13calculation.php	File
13calculation.xlsx	File
13calculationCyclicFormulae.php	File
13calculationCyclicFormulae.xlsx	File
14excel5.php	File
14excel5.xls	File
15datavalidation-xls.php	File
15datavalidation-xls.xls	File
15datavalidation.php	File
15datavalidation.xlsx	File
16csv.csv	File
16csv.php	File
16csv.xlsx	File
16csv_excel.csv	File
17html.htm	File
17html.php	File
18extendedcalculation.php	File
19namedrange.php	File
19namedrange.xlsx	File
20readexcel5.php	File
20readexcel5.xlsx	File
21pdf.php	File
22heavilyformatted.php	File
22heavilyformatted.xls	File
22heavilyformatted.xlsx	File
23sharedstyles.php	File
23sharedstyles.xls	File
23sharedstyles.xlsx	File
24readfilter.php	File
24readfilter.xlsx	File
25inmemoryimage.html	File
25inmemoryimage.php	File
25inmemoryimage.xlsx	File
26utf8-bom.csv	File
26utf8.csv	File
26utf8.htm	File
26utf8.php	File
26utf8.xls	File
26utf8.xlsx	File
27imagesexcel5.php	File
27imagesexcel5.xls	File
27imagesexcel5.xlsx	File
28iterator.php	File
29advancedvaluebinder.php	File
29advancedvaluebinder.xls	File
29advancedvaluebinder.xlsx	File
30template.php	File
30template.xls	File
31docproperties_write-xls.php	File
31docproperties_write-xls.xls	File
31docproperties_write.php	File
31docproperties_write.xlsx	File
32chartreadwrite.php	File
32readwriteAreaChart1.xlsx	File
32readwriteAreaChart2.xlsx	File
32readwriteAreaChart3.xlsx	File
32readwriteAreaChart3D1.xlsx	File
32readwriteAreaPercentageChart1.xlsx	File
32readwriteAreaPercentageChart2.xlsx	File
32readwriteAreaPercentageChart3D1.xlsx	File
32readwriteAreaStackedChart1.xlsx	File
32readwriteAreaStackedChart2.xlsx	File
32readwriteAreaStackedChart3D1.xlsx	File
32readwriteBarChart1.xlsx	File
32readwriteBarChart2.xlsx	File
32readwriteBarChart3.xlsx	File
32readwriteBarChart3D1.xlsx	File
32readwriteBarPercentageChart1.xlsx	File
32readwriteBarPercentageChart2.xlsx	File
32readwriteBarPercentageChart3D1.xlsx	File
32readwriteBarStackedChart1.xlsx	File
32readwriteBarStackedChart2.xlsx	File
32readwriteBarStackedChart3D1.xlsx	File
32readwriteBubbleChart1.xlsx	File
32readwriteBubbleChart3D1.xlsx	File
32readwriteChartWithImages1.xlsx	File
32readwriteColumnChart1.xlsx	File
32readwriteColumnChart2.xlsx	File
32readwriteColumnChart3.xlsx	File
32readwriteColumnChart3D1.xlsx	File
32readwriteColumnChart4.xlsx	File
32readwriteColumnPercentageChart1.xlsx	File
32readwriteColumnPercentageChart2.xlsx	File
32readwriteColumnPercentageChart3D1.xlsx	File
32readwriteColumnStackedChart1.xlsx	File
32readwriteColumnStackedChart2.xlsx	File
32readwriteColumnStackedChart3D1.xlsx	File
32readwriteDonutChart1.xlsx	File
32readwriteDonutChart2.xlsx	File
32readwriteDonutChart3.xlsx	File
32readwriteDonutChart4.xlsx	File
32readwriteDonutChartExploded1.xlsx	File
32readwriteDonutChartMultiseries1.xlsx	File
32readwriteLineChart1.xlsx	File
32readwriteLineChart2.xlsx	File
32readwriteLineChart3.xlsx	File
32readwriteLineChart3D1.xlsx	File
32readwriteLineChartNoPointMarkers1.xlsx	File
32readwriteLinePercentageChart1.xlsx	File
32readwriteLinePercentageChart2.xlsx	File
32readwriteLineStackedChart1.xlsx	File
32readwriteLineStackedChart2.xlsx	File
32readwritePieChart1.xlsx	File
32readwritePieChart2.xlsx	File
32readwritePieChart3.xlsx	File
32readwritePieChart3D1.xlsx	File
32readwritePieChart4.xlsx	File
32readwritePieChartExploded1.xlsx	File
32readwritePieChartExploded3D1.xlsx	File
32readwriteRadarChart1.xlsx	File
32readwriteRadarChart2.xlsx	File
32readwriteRadarChart3.xlsx	File
32readwriteScatterChart1.xlsx	File
32readwriteScatterChart2.xlsx	File
32readwriteScatterChart3.xlsx	File
32readwriteScatterChart4.xlsx	File
32readwriteScatterChart5.xlsx	File
32readwriteStockChart1.xlsx	File
32readwriteStockChart2.xlsx	File
32readwriteStockChart3.xlsx	File
32readwriteStockChart4.xlsx	File
32readwriteSurfaceChart1.xlsx	File
32readwriteSurfaceChart2.xlsx	File
32readwriteSurfaceChart3.xlsx	File
32readwriteSurfaceChart4.xlsx	File
33chartcreate-area.php	File
33chartcreate-area.xlsx	File
33chartcreate-bar-stacked.php	File
33chartcreate-bar-stacked.xlsx	File
33chartcreate-bar.php	File
33chartcreate-bar.xlsx	File
33chartcreate-column-2.php	File
33chartcreate-column-2.xlsx	File
33chartcreate-column.php	File
33chartcreate-column.xlsx	File
33chartcreate-composite.php	File
33chartcreate-composite.xlsx	File
33chartcreate-line.php	File
33chartcreate-line.xlsx	File
33chartcreate-multiple-charts.php	File
33chartcreate-multiple-charts.xlsx	File
33chartcreate-pie.php	File
33chartcreate-pie.xlsx	File
33chartcreate-radar.php	File
33chartcreate-radar.xlsx	File
33chartcreate-scatter.php	File
33chartcreate-scatter.xlsx	File
33chartcreate-stock.php	File
33chartcreate-stock.xlsx	File
34chartupdate.php	File
34chartupdate.xlsx	File
35chartrender.php	File
36chartreadwriteHTML.php	File
36chartreadwritePDF.php	File
37page_layout_view.php	File
37page_layout_view.xls	File
37page_layout_view.xlsx	File
38cloneWorksheet.php	File
38cloneWorksheet.xlsx	File
39dropdown.php	File
39dropdown.xlsx	File
40duplicateStyle.php	File
40duplicateStyle.xlsx	File
41password.php	File
41password.xls	File
41password.xlsx	File
42richText.php	File
42richText.xls	File
42richText.xlsx	File
43mergeWorkbooks.php	File
43mergeWorkbooks.xlsx	File
44worksheetInfo.php	File
Excel2003XMLReader.php	File
Excel2003XMLReader.xls	File
Excel2003XMLTest.xml	File
GnumericReader.php	File
GnumericReader.xlsx	File
GnumericTest.gnumeric	File
OOCalcReader.php	File
OOCalcReader.xlsx	File
OOCalcReaderPCLZip.php	File
OOCalcReaderPCLZip.xlsx	File
OOCalcTest.ods	File
Quadratic.php	File
Quadratic.xlsx	File
Quadratic2.php	File
SylkReader.php	File
SylkReader.xlsx	File
SylkTest.slk	File
XMLReader.php	File
XMLReader.xlsx	File
XMLTest.xml	File
error_log	File
runall.php	File