report colours

Hi

I have a report with 2 charts on it (a pie chart and a graph). The series are set out as :

pie chart

series 1 -total 1 - red

series 2 - total 2 - blue

series 3 - total 3 - yellow

series 4 - total 4 - green

graph (stacked)

series 1 -total 1 - green

series 2 - total 2 - red

series 3 - total 3 - blue

series 4 - total 4 - yellow

as the 2 charts refer to the same info, i would like the colours of both sets of series to be identical - how can i do this?

The colors for each of the series should be identical in each of the charts, as long as the charts are set up the same way, with the values, series, and categories in the same order. Since a Pie chart can only have display one series, there is some behind the scenes magic that takes place to convert a chart with multiple series into one series. This may cause issues with having the colors be identical.

If this is the case, adjusting the order of the various added fields may resolve the issue. If this does not help, then you may need to write some custom code that looks up the correct color based on information during report processing.

I would first take a look at the order of values, series, and categories, and if adjusting the order does resolve the issue, I can help you create some custom code to get the correct color for the series.

Ian|||

thanks for the reply Ian. I got around the problem in the end by adding an additional column to the database which contains the colour references. I then use this column in the chart properties appearance. Not the best way to fix the problem, I admit - however, as the table is a reference table which is not likely to alter for some time (if at all) - it works...