Additional bar chart colours

[johnstrang]

Hi,

Using CR 8.5.

I have a stacked bar chart, showing fault categories per week.
Data in chart is
Oh change of Week Number ; Category
Show Values: Count of faults.

Category is set to TopN, where N=5 (include others), so for any given week only the top 5 categories are displayed.

Everything works fine, but as the year has progressed, more are more categories are being included in the top 5 for different weeks.
An extreme example:
Week 1: Categories A B C D E
Week 2: Categories F G H I J
Week 3: Categories K L M N O
Week 4: Categories P Q R S T

This has resulted in the same colours being used for different categories - the legend includes 17 (a strange number?) colours; so in my above example category R would have the same colour as category A, S same as B, T same as C.

Is it possible to either:
1. Have more colours available, or
2. Have an overall TopN for the whole chart?
3. Any other suggestions?

Thanks in advance,

John

PS The users have not noticed yet :-D

 

[vidru]

I think this might help you out:

Creating a Bar Chart that Retains Bar Colors for Specified Data


-dave