Chart's options in excel export

Epitello commented on Oct 4, 2021

Hi,

During an excel export, how does it possible to keep custom css of a chart ?

I tried to pass the same "colorScheme" but it seems to be ignored in excel. I also tried to pass the "excelStyle" property but it doesn't change anything. Did I miss something?

Thanks

Sebastian Morales commented on Oct 5, 2021

It's unfortunate colors and font styles are not yet options for Excel's Chart widget. We will explore them in the future version of the Excel package. If you have any recommendation about this let us know. Tks,

Epitello commented on Oct 5, 2021

I have others questions about options of excel export:

Is it possible to show values in charts ? For example, show percent values in a pie chart. If it's possible, the data formatting will be recovered from the options chart ?
About Cards, Are they managed in the excel export ?
For the 3D's chart, is it possible to specify 3D angle ?

Thanks

Sebastian Morales commented on Oct 7, 2021

1 . Here're most of the current chart options:

        BarChart::create(array(
            ...
            'title' => 'Customer Sales by Quarter',
            'xAxisTitle' => 'Customers',
            'yAxisTitle' => 'Sales($)',
            'stacked' => true,
            'direction' => 'horizontal',
            'layout' => [
                'showValue' => true,
                'showPercent' => true,
                'showSerName' => true,
                'showLeaderLines' => true,
                'showBubbleSize' => true,
                'showCatName' => true,
                'showLegendKey' => true,
            ],
            "legend" => [
                "position" => 'r', // 'r', 'l', 't', 'b', 'tr'
            ],
        ));

2 . Card widget is not avaiblable yet, but you could use Text widget with excelStyle for similar purpose. Pls check our excel export example for the excel style array values.

3 . 3D chart's angle is an option yet.

Epitello commented on Oct 8, 2021

It works !

Thanks

KoolReport's Forum

Chart's options in excel export #2370

Build Your Excellent Data Report