KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Charts are not created on the excel speadsheet #1550

Open Yanick Ileo opened this topic on on Aug 2, 2020 - 2 comments

Yanick Ileo commented on Aug 2, 2020

hi , i tried to add the charts on excel download , i can see the chart_data sheet , but there is no chart on the excel document , please assist

David Winterburn commented on Aug 3, 2020

Hi,

The current version of Excel package has some chart open issue in Microsoft Office. We will fix that in the next release of KoolReport. Meanwhile you could try this fix to see if it works. Please open the file koolreport/excel/Chart.php and replace the following line:

        $chart = new PHPOfficeChart(
            $chartName, // name
            $title, // title
            $legend, // legend
            $plotArea, // plotArea
            true, // plotVisibleOnly
            0, // displayBlanksAs
            $xAxisLabel, // xAxisLabel
            $yAxisLabel,  // yAxisLabel
            $yaxis,
            $xaxis
        );

with these:

        $chart = new PHPOfficeChart(
            $chartName, // name
            $title, // title
            $legend, // legend
            $plotArea, // plotArea
            true, // plotVisibleOnly
            'gap', // displayBlanksAs
            $xAxisLabel, // xAxisLabel
            $yAxisLabel,  // yAxisLabel
            $yaxis,
            $xaxis
        );

Thanks!

Yanick Ileo commented on Aug 11, 2020

Thank you very much , it working fine now

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
bug
solved

None