I have a small problem with defining the colors of a bar chart which contains bars per quarter. I've created the following chart by defining colors 1 to 18 manually:
this contains 16 quarters and after a year the coloring scheme is repeated. But I want to add the option to expand the dates so when the chart exceeds 18 quarters the coloring scheme does no longer match. see example:
bars 'apr-jun 2009' and 'jan-mrt 2009' do not fit the scheme because they are colors 1 and 2 of the colors properties.
does anyone have an idea how to fix this easily (without having to add an extensive expression to the dimension)?