Non-contiguous range in chart

[suseu]

I am trying to create chart with non-contiguous data range. In Excel I simply separate ranges with a comma, e.g.

=('Chart'!$C$2:$C$5,'Chart'!$C$7:$C$10)

but when I do this in PHPExcel I get such error:

Formula Error: Unexpected , (0)
#0 \PEAR\PHPExcel\PHPExcel\Calculation.php(2893): PHPExcel_Calculation->_raiseFormulaError('Formula Error: ...')
#1 \PEAR\PHPExcel\PHPExcel\Calculation.php(2404): PHPExcel_Calculation->_parseFormula(''Technical vs H...', Object(PHPExcel_Cell))
#2 \PEAR\PHPExcel\PHPExcel\Chart\DataSeriesValues.php(288): PHPExcel_Calculation->_calculateFormulaValue('='Technical vs ...', NULL, Object(PHPExcel_Cell))
#3 \PEAR\PHPExcel\PHPExcel\Chart\DataSeries.php(342): PHPExcel_Chart_DataSeriesValues->refresh(Object(PHPExcel_Worksheet), true)
#4 \PEAR\PHPExcel\PHPExcel\Chart\PlotArea.php(121): PHPExcel_Chart_DataSeries->refresh(Object(PHPExcel_Worksheet))

Is it even possible to create charts from non-contiguous data? If so - how do I do it?
If not - are you planning to add such feature?

[abdulkader87]

I have same problem did you find a solution??

[garethellis36]

I had the same issue. I have developed a workaround. In my code I am opening an existing template and writing data into it - saves time styling the spreadsheet with PHPExcel. I created an additional sheet called 'Hidden' and put cells pointing to the main, 'live' sheet within it.
Then you just create the chart based off the hidden sheet, which should now have all the data you need in a contiguous range.

[ComputerTinker]

@suseu , @abdulkader87 , and @garethellis36 , I just created PR #650 to fix the issue PHPExcel has with comma separated chart data source values. If you have your own fork of PHPExcel, you can merge the patch, otherwise feel free to download from https://github.com/ComputerTinker/PHPExcel, which is up-to-date with /PHPOffice/PHPExcel but has the new patch applied. Everything worked fine in my tests, but let me know if you run into any issues.