Problemstatement If you have done a chart and want tu use the possibiliy, to define the border colour and the fill colour of each data series and want to know, which number entries in it cells should be written for which colour, the help text shows no explanation for both possible data series (see PNG). See the example file colornumbers4dataseries.ods with a chart: If you write some numbers in the cells, see D11:F13(as much as one data series have entries) they were interpreted as colour, but which number is which colour (or is it a RGB number in 3 cells)? Hitting the help button when having the data range assistant activated via symbol bar brings no explantaion for these border and fill range. Expected behavior: you could use the name of a colour (e.g. Magenta, or gray 3 or s.l.t.) or at least an explanation in the help text, how this two data ranges have to be filled for a data series to get a specifik colour or a table of numbers corresponding to the colours. Also I would expect, that the legend is updated with this colours, see in the example file, the old colours of the chart assistant are still shown. Is it something like a hard formatting of color properties of data series? Can someone help with this?
Created attachment 125883 [details] examples ods with a chart and trail and error for range of filling colors
Created attachment 125884 [details] screenshot of the data range wizzard with possibility to enter y range of fill colours or border colors
Perhaps I should add, if someone confirmes and gives me the information needed I will volounteer to add it to the help system ;-) Thanks a lot Lothar
Thank you for offering to improve our help contents. The file to correct is wiz_data_series.xhp You can see it live here: vm173.documentfoundation.org/text/schart/01/wiz_data_series.xhp There are 2 ways to fix this, the long way and the quick way. The quick way is to write the content/modifications and attach it here, as a single text file (or odt file) and I will create a patch with your authorship and add to LO help. Or you can do it yourself by editing and patching the file wiz_data_series.xhp in the source code (needs knowledge with git/gerrit/XHP files+schema/compile/test/submit).
OK, in the meantime I tried and failed and tried and get the answer ;-) For each cell of the data row (which is activated in the left listbox) you can define the colour for the filling and the border with the number of the hexcode of RGB colours, it is easy if you use the =Hexindez("<hex of colour>") and the hex representation of a colour you can find out via any colour dialog with a user defined colour at the bottom in the RGB area. So if you want to give the diagramm field of a specific data item a spedial colour you can do this via the propertie of Filling colour in the data range writing the number representation of the hex code of the colour like =Hexindez("020202") for the color black.