Chart line style

Topics: Developer Forum
Nov 17, 2012 at 11:29 AM
Edited Nov 17, 2012 at 11:30 AM

Is there any option for setting line chart style. In output chart line Width is coming .75 and I am looking to set 2.50 , smooth curve without markers.

I am using  version 1.7.8.

I tried below line.

$series = new PHPExcel_Chart_DataSeries(                       

PHPExcel_Chart_DataSeries::TYPE_LINECHART, // plotType                        PHPExcel_Chart_DataSeries::GROUPING_STANDARD, // plotGrouping

range(0, count($dataSeriesValues) - 1), //plotOrder                        

$dataseriesLabels, // plotLabel                       

$xAxisTickValues, // plotCategory                       

$dataSeriesValues, // plotValues                       

TRUE //Smooth line   );

 

Thanks,

Bharat

Feb 5, 2014 at 3:17 PM
I tried edit it using Excel while seeing changes in xml files and I've discovered that it affected atrribute w in element ln.

I found that 1 pt is 12700 and in the code here's my change - so far hardcoded to writer, next time I'l do it differently.

Writer/Excel2007/Chart.php:788
                $objWriter->startElement('c:spPr');
                    $objWriter->startElement('a:ln');
                        // rf - line 3pt thick
                        $objWriter->writeAttribute('w', 3 * 12700);
                        // $objWriter->writeAttribute('w', 12700);
                    $objWriter->endElement();
                $objWriter->endElement();