Thursday, March 8, 2012

Assigning Colors to bar charts

Hi there folks,

Would really appreciate it if i could get some help on this matter,

I have a bar chart that displays 3 bars. 3 separate colors have been assigned to each bar depending on the group it represents.

The problem is each time there is different data being pumped into the graph the assigned color of each bar keeps getting switched. Is there anyway that we could permanently assign a color to a bar ??

Thanking you in advance for your help.Hi,

When you say the colours have been assigned to a specific bar do you mean through the Chart Colour Format Expert? If you do then I would suggest you play around with which field or value you are using within the parameters.

If you dont then go to: Right-click chart> Chart Expert> Untick Automatically set chart options> Options Tab> Chart Colour Format Button.

In here (it is very similar to the Select Expert) you can assign a specific colour to a given parameter (i.e. if {SO_Header.SO_No} in 10000 to 20000 then the bar will appear red and so on)

If you have tried this and it still goes screwy when the values change then I would suggest building in a tollerance. So instead of saying if {woteva} = 10 then woteva, build in a comfort zone by using the <in to> operators as above.

Hope this helps. Please post results for other users and for any more help.

Take it easy

RobV

No comments:

Post a Comment