Change bar color based on marker line

HI .

I have one bar chart showing no sales person on X axis and quantity sold by him on y axis .
There is a marker line Showing 100 quantity mark , and when bar cross this mark its color should change to gray.

How to do that, please help

lrnit

Find more posts tagged with

Comments

mwilliams

Take a look at this example from the devShare. It's from an old version of BIRT, but it should show you how to do this! Let me know if you have issues!

http://www.birt-exchange.org/org/devshare/designing-birt-reports/276-birt-chart-scripting-dynamic-markers-and-datapoint-colors/

Yogesh Maharwade

Hi mike
can we have color change of the bar graph above threshold line.
letting all the bar graphs of same color. (taking into the fact that i have only one threshold line).

piwya

mwilliams

How do you determine your threshold line? Does it come by a parameter? The linked example above should help with that still.

Or are you wanting to change all bar colors in the chart if you reach a threshold value in one bar? Let me know.

Yogesh Maharwade

i want to change bar color like attached image above threshold line.And threshold line is static.

mwilliams

Oh, I see what you mean. I'm pretty sure this isn't possible with a single bar, however, you could probably do this with a stacked bar chart. I haven't tried it, but you'd just check the value of the field you're showing in the chart for the threshold value. If it meets it, you show the threshold for series one and show the value - the threshold for series 2. If it doesn't meet the threshold, you don't show a value for series 2. Let me know if this makes sense. I can make a sample if you provide your BIRT version.

Yogesh Maharwade

Version is Birt 2.6.1

mwilliams

Take a look at this design. Let me know if you have questions.

Yogesh Maharwade

Thank you very much for your help

piwya

mwilliams

You're welcome!