Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Excel::Writer::XLSX - pie chart legend's color

by jmcnamara (Monsignor)
on Sep 28, 2012 at 08:48 UTC ( #996141=note: print w/replies, xml ) Need Help??

in reply to Excel::Writer::XLSX - pie chart legend's color

It is possible to define chart colors for most types of Excel::Writer::XLSX charts via the add_series() method.

However, Pie charts in Excel are a special case since each pie segment is actually a point and there isn't currently any way in Excel::Writer::XLSX to define colors for individual points.

The set_style() method, which you are using, is currently the only way of changing Pie chart colours.