Is there a way to change the color of a data label on a bar chart when it is above the value of a reference line?

Thanks.

This message has been edited. Last edited by: DWaybright,

Possibly, what is the format of the chart ?

I'm using *GRAPH_SCRIPT to format it. This is part of a compound PDF I inherited.

How about using:

setFillColor(getDataText(),new Color(255,0,0));

in the "*GRAPH_SCRIPT" block?

Or, you could use the following, if you have multiple series:

setFillColor(getDataText(0), new Color(0,0,255));
setFillColor(getDataText(1), new Color(0,155,127));
setFillColor(getDataText(2), new Color(0,255,64));
setFillColor(getDataText(3), new Color(255,128,0));
setFillColor(getDataText(4), new Color(255,0,0));

@Doug - that changes all the values to red, not just the ones over the reference line.

You could use a stacked bar chart and calculate the vales, and colors, based on the value of the reference line. A bit complex, but doable.

Or, calculate / use the colors as used in my 14:05 based on the comparison to the value of the reference line.

@Doug,
Thanks. I was hoping for something relatively simple. Guess I should have known better.

quote:

I was hoping for something relatively simple. Guess I should have known better.

Yeah, don't we all?