Create multi color bar in PHPExcel Charts

Question

I want to create a bar chart using PHPExcel in multi color means every bar can contain multi color as shown below.

enter image description here

I have searched it out but couldn't be able to find out the solution.

Second question how can I increase width of bar?

Best Regards

score 1 · Accepted Answer · answered Sep 30 '13 at 07:01

1

It's a stacked column chart, so you need to set the plotGrouping to PHPExcel_Chart_DataSeries::GROUPING_STACKED

See /Examples/33chartcreate-bar-stacked.php for an example

but set $series->setPlotDirection(PHPExcel_Chart_DataSeries::DIRECTION_COLUMN); to stack vertically rathe rthan horizontally

answered Sep 30 '13 at 07:01

Mark Baker

Seen that file, but don't know how to make a bar as multi color. In that file there is nothing like this – Awais Qarni Sep 30 '13 at 07:06
Each column should show as three different colours to represent the different values in that bar – Mark Baker Sep 30 '13 at 07:09
Yes asking how can I change color option for each column? Because Haven't found any way to change color and especially like this. – Awais Qarni Sep 30 '13 at 07:12
Actually I want to give color as I like. Is it possible to give color as you like? – Awais Qarni Sep 30 '13 at 07:18
And One thing more how to write on a bar? Means some text on bar? – Awais Qarni Sep 30 '13 at 07:42
Please answer this question. http://stackoverflow.com/questions/19094890/some-questions-about-phpexcel-charts – Awais Qarni Oct 01 '13 at 04:37

1 Answers1