Thanks for this, but I can't understand how I can do it. It is a stacked bar graph displaying more series. In vertical I have the "owners", in horizontal I have the "number of appointment"and
the "appointment type" for the current day. And every day I look at the graph, the appointment types have different colours in the legend key....as the type of appointment changes.
Exporting the chart, I think the part ruling the colours is this one:<o:p></o:p>
<Chart Palette="None"PaletteCustomColors="149,189,66; 197,56,52; 55,118,193; 117,82,160;49,171,204;
255,136,35; 168,203,104; 209,98,96; 97,142,206; 142,116,178; 93,186,215; 255,155,83"><o:p></o:p>
But as far as I know, the color options and the series are applied in parallel, which means that the first series displayed in the chart will get the first color listed. This is the
standard way MS applies the colours. If tomorrow in my chart, the order of the series is different, also the colours for the above reason will be different.<o:p></o:p>
How can you link "forever" the "appointment type" with a certain colour avoiding this criteria "first
series displayed/first colour applied"?
