MNB PHPExcelDeveloper Guide
v2.0.5
Documentation versions v2.0.5Current v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →

Charts examples

Charts Excel examples, explained clearly.

Open a focused example to see the implementation path, copy-ready PHP, expected workbook behavior, and the production boundary that matters.

Open first example View all 92 examples
4examples in this category
21focused categories
5implementation paths
← All 92 examples
01
Column Chart

Create a native column chart from category and value ranges.

EasyDirect API
addChart()
column-chart.php
<?php

use Mnb\PHPExcel\MnbExcel;

MnbExcel::fromArray($monthlySales)
    ->withHeader()
    ->addChart('column', 'Monthly Sales', [[
        'name' => 'Sales',
        'categories' => 'Sheet1!$A$2:$A$13',
        'values' => 'Sheet1!$B$2:$B$13',
    ]], ['from' => 'D2', 'to' => 'L18'])
    ->save('column-chart.xlsx');
02
Line Chart

Plot a sequence over time as a native line chart.

EasyDirect API
addChart()
line-chart.php
<?php

use Mnb\PHPExcel\MnbExcel;

MnbExcel::fromArray($dailyTraffic)
    ->withHeader()
    ->addChart('line', 'Daily Traffic', [[
        'name' => 'Visits',
        'categories' => 'Sheet1!$A$2:$A$31',
        'values' => 'Sheet1!$B$2:$B$31',
    ]], ['from' => 'D2', 'to' => 'L18'])
    ->save('line-chart.xlsx');
03
Pie Chart

Create a pie chart for a small set of mutually exclusive categories.

EasyDirect API
addChart()
pie-chart.php
<?php

use Mnb\PHPExcel\MnbExcel;

MnbExcel::fromArray($salesByCategory)
    ->withHeader()
    ->addChart('pie', 'Sales Mix', [[
        'name' => 'Amount',
        'categories' => 'Sheet1!$A$2:$A$6',
        'values' => 'Sheet1!$B$2:$B$6',
    ]], [
        'from' => 'D2',
        'to' => 'K17',
        'legend' => 'right',
        'vary_colors' => true,
    ])
    ->save('pie-chart.xlsx');
04
Combo Chart

Preserve a trusted template when one chart must combine different chart types or use a secondary axis.

MediumTrusted template
preserveAdvancedObjectsFrom()
combo-chart.php
<?php

use Mnb\PHPExcel\MnbExcel;

MnbExcel::fromArray($revenueAndMargin)
    ->withHeader()
    ->preserveAdvancedObjectsFrom('templates/revenue-combo-chart.xlsx')
    ->save('revenue-combo-chart-output.xlsx');