Options for Charts

[chuebert]

Hi,

it is possible to have charts like this:

In the left chart i want have the values on the left line and not by the points.
In the secon chart i want no paddings in the cake.

and it is possible to use percent by countet value or must i calculate it by my self?

[Progi1984]

@chuebert :

For labels hidden on the points,

$series = new Series('Downloads', $seriesData);
$series->setShowValue(false);

For the padding of the explosion of the pie3d, I add a option (cf. Sample_07.php l.135).

For defining values as percent,

$series = new Series('Downloads', $seriesData);
$series->setShowPercentage(true);

[chuebert]

Okay thank you very much, it works fine :)

[Progi1984]

@chuebert Have you the last version of the develop branch ?

l.135 : 85d60c3#diff-e264001d18a8efadcb0fd9fa04610a88R135

[chuebert]

Yes i have it now, but the $pie3DChart->setExplosion(10); doesnt change anything

[Progi1984]

$pie3DChart->setExplosion(0);

$pie3DChart->setExplosion(10);

$pie3DChart->setExplosion(20);

[chuebert]

okay thank you ;)

[Progi1984]

@chuebert After your tests, if it's ok for you, I will close this issue. Thanks for advance.

[Progi1984]

@chuebert It's ok for you ?

[chuebert]

Now i have this:

the explosion doesnt work, why?
On linechart i have no values on the left. It is possible to set them?

Here is my code:

        public function createChartSlide($slide, $tonalityData, $matchesData) {

        /* CREATE TEXT */
        $shape = $slide->createRichTextShape();
        $shape->setHeight(200);
        $shape->setWidth(640);
        $shape->setOffsetX(20);
        $shape->setOffsetY(100);
        $shape->getActiveParagraph()->getAlignment()->setHorizontal(Alignment::HORIZONTAL_LEFT);

        if ($this->user_id != 11 && $this->user_id != 17) {
            $textRun = $shape->createTextRun('Zusammenfassung');
            $textRun->getFont()->setBold(false);
            $textRun->getFont()->setSize(28);
            $textRun->getFont()->setColor(new Color($this->defaultTextColor));
        }

        /* Create a pie chart (that should be inserted in a shape) */
        $pie3DChart = new Pie3D();
        $pie3DChart->setExplosion(0);
        $series = new Series('Downloads', $tonalityData);
        $series->setShowPercentage(true);
        $series->setShowSeriesName(false);
        $series->getDataPointFill(0)->setFillType(Fill::FILL_SOLID)->setStartColor(new Color('FF4672A8'));
        $series->getDataPointFill(1)->setFillType(Fill::FILL_SOLID)->setStartColor(new Color('FF8AA64F'));
        $series->getDataPointFill(2)->setFillType(Fill::FILL_SOLID)->setStartColor(new Color('FFAB4744'));
        $pie3DChart->addSeries($series);

        /* Create a shape (chart) */
        $shape = $slide->createChartShape();
        $shape->setName('tonalität')
                ->setResizeProportional(false)
                ->setHeight(360)
                ->setWidth(500)
                ->setOffsetX(520)
                ->setOffsetY(300);
        $shape->getTitle()->setText('Tonalität der Beiträge');
        $shape->getTitle()->getFont()->setItalic(true);
        $shape->getTitle()->getOffsetX(300);
        $shape->getPlotArea()->setType($pie3DChart);
        $shape->getView3D()->setRotationX(40);
        $shape->getView3D()->setPerspective(10);
        $shape->getLegend()->getBorder()->setLineStyle(Border::LINE_SINGLE);
        $shape->getLegend()->getFont()->setItalic(true);

        /* Create a line chart (that should be inserted in a shape) */
        $lineChart = new Line();
        $series = new Series('', $matchesData);
        $series->setShowValue(false);
        $series->setShowSeriesName(true);
        $lineChart->addSeries($series);

        /* Create a shape (chart) */
        $shape = $slide->createChartShape();
        $shape->setName('Trefferhäufigkeit')
                ->setResizeProportional(false)
                ->setHeight(360)
                ->setWidth(460)
                ->setOffsetX(40)
                ->setOffsetY(300);
        $shape->getTitle()->setText('Trefferhäufigkeit der Beiträge');
        $shape->getTitle()->getFont()->setItalic(true);
        $shape->getPlotArea()->setType($lineChart);
        $shape->getView3D()->setRotationX(30);
        $shape->getView3D()->setPerspective(30);
        $shape->getLegend()->getBorder()->setLineStyle(Border::LINE_SINGLE);
        $shape->getLegend()->getFont()->setItalic(true);
    }

[chuebert]

How can i remove the legend on line chart? ;)

[Progi1984]

@chuebert

• For the explosion, have you the last version of the develop branch with modifications on PowerPoint2007 Writer ? Because I have no problem here.
• For lineChart and values on left, I have a bug. If you have PowerPoint, could you send me a PPTX with a slide with a line chart with values on Y axis and a slide with a line chart with no values on Y axis, please ?
• For disabling the legend :

$shape->getLegend()->setVisible(false);

[chuebert]

[DELETE]

[Progi1984]

@chuebert I think you have sent me a PHPPowerPoint generated file. I need an Office PowerPoint generated file for having the right XML and find the difference with PHPPowerPoint.

[chuebert]

ah okay ;)

[chuebert]

[DELETE]

[chuebert]

I have update my phppowerpoint folder again and now it works ;)
Only the linechart with values on the left doesnt work, thank you for solving the problem ;)

[Progi1984]

For the lineChart with values, you must define the format because there are values :

$shape->getPlotArea()->getAxisY()->setFormatCode('#,##0');

[chuebert]

Thank you very much, its working fine :) Happy New Year ;)

[Progi1984]

Thanks :)

[manikrds]

Hi

Is it possible to have chart like this ?

[Progi1984]

@manikrds At the moment, no.

You can have line charts but without arrow and top legend.

[manikrds]

@Progi1984 Thanks for your comment

[manikrds]

@Progi1984 Sorry for the same question.

Is Possible to have graph chart like this ??

[Progi1984]

@manikrds At the moment, no.

You can have line charts but without filling zone under.

If you want implementation, create an issue for each feature which miss you in PHPPowerPoint.