Consistent colors in charts

[svedec]

Hi everyone,

I am facing this difficulty :

I want to indicate where my user is in a range of data in a chart, as well as where the average is.
That's not too difficult, that part I figured out already :)

However, if I have several charts in 1 report, my "user bar'" sometimes gets a different color, according whether it's below or above average.
This is very confusing for my users, because they can't think, let's say, "the yellow bar is always me".
The legend always has to be read, and that's not so user-friendly.

I'll illustrate the problem in an attachment.

I know how to have the same series color, but within this series, I want 1 particular color to always represent the value of the average, another to represent my user, etc.

Is this possible ?!
Thanks a lot in advance.

Post Edited by svedec at 12/21/2011 12:59