Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Chart: match data color to cell

I recently abandoned Excel in favour of LibreOffice Calc, because I was running into some hardcoded limitations of Excel (namely only being able to plot 255 data series in a single chart) that don't seem to exist in LibreOffice.

As you can imagine having a chart with over 255 data series it's important to have full control over the colour for each series. In Excel I managed this with a macro that picked the colour for each series based on the cell colour of its header.

Is there a way to do this in LibreOffice Calc?