I am having trouble with the colors on a bar chart. I have a chart that displays a series of paired bar charts, displaying the number of new and closed service requests for each month over a 13 month period. So in the chart expert I have 2 values in the "on change of" box (month and type - the only 2 values for type are 'new' and 'closed'), and one value in the 'show values' box - count of monthly service requests. I choose Navy for the 'closed' type and silver for the 'new' type. So I should se a chart with 13 pairs of silver and navy bars corresponding to the monthly counts.
The problem is that some of the bars are the wrong color. The first silver bar actually displays blue and the second navy bars displays yellow. There are several posts that reference a knowledge base article explaining how to use formulas to force the bars to be the right colors, but they refer to charts that only use one 'on change of' value, the chart expert doesn't allow multiple 'on change of' values with multiple 'show values' values.
I have another similar chart with 13 sets of 4 monthly bars. An interesting pattern emerges, for the first month in the chart, the left-most bar is the wrong color, for the 2nd month, the next bar is discolored, the 3rd month and the 3rd bar is discolored, same pattern with the 4th month. All of the other bars for all other months are the correct color.
I am using Crystal Reports XI R2. So far Business Objects hasn't come up with a solution.
The problem is that some of the bars are the wrong color. The first silver bar actually displays blue and the second navy bars displays yellow. There are several posts that reference a knowledge base article explaining how to use formulas to force the bars to be the right colors, but they refer to charts that only use one 'on change of' value, the chart expert doesn't allow multiple 'on change of' values with multiple 'show values' values.
I have another similar chart with 13 sets of 4 monthly bars. An interesting pattern emerges, for the first month in the chart, the left-most bar is the wrong color, for the 2nd month, the next bar is discolored, the 3rd month and the 3rd bar is discolored, same pattern with the 4th month. All of the other bars for all other months are the correct color.
I am using Crystal Reports XI R2. So far Business Objects hasn't come up with a solution.