Change the color of 1 word in a formula for charts

[pb100]

Hi all,
I am using CRXI and SQL. I have charts where the On Chg Of formula is a concatenated string of 2 formula values. Is there a way to set the color of the second value to white (so it does not appear in the axis label). My formula looks something like this:
{@axis label}&" " &{@sort value}

I would like the sort value to show up as transparent or white so it's "invisible" but still used to sort the bars in the chart.

Thanks for any help!
Cheers,
pb

 

[lbass]

You will have to show us the content of the two formulas.

-LB

 

[pb100]

Hi lb,
The axis label formula is a string: totext(year(date),"#").
The sort value formula is also a string:
If isnull(field1) then "a" else "b".

I would like the a and b part of the labels to be "invisible".

Thanks for your help!
-pb

 

[lbass]

Well, but what it the point of the a and b? There might be a way of simply eliminating them, but I don't see what they add right now.

-LB

 

[pb100]

Hi lb,
In my chart, I have stacked bars and lines (1 OnChgOf and 2 ShowValues). The OnChgOf is by Year-a or Year-b and then bars for ShowValue1 and a line for ShowValue2. Year-a and Year-b are different colors and appear as separate bars even though they are stacked(another great workaround I found on this forum). I do not want Year-a and Year-b to combine into 1 bar, they need to show up as separate colors but I would love to be able to make the 'a' and 'b' part of the name invisible.

Any ideas?
Thanks so much!
-pb

 

[lbass]

I'm not following what the a and b do--why is this necessary? Maybe if you had identified the real field instead of using "field" I would have a better idea. What is the difference between year-a and year-b?

-LB

 

[pb100]

Hi lb,
My Chart has bars that read:
2006-a, 2006-b, 2007-a, 2007-b. The 'a' bars are yellow and the 'b' bars are blue and represent the national(a) or regional(b) sales values. My custom graphic legend indicates that yellow = National Sales and blue = Regional Sales. My customer just wants to see the year values as labels under each bar since the colors delineate if they are national or regional. If my OnChgOf shows just year, then I will not get the regional and national values as separate bars. I may just have to change a and b to read National and Regional and hope my customer can live with that. I saw in one post that it might be possible to use html tags in text strings to change a font color but not sure that works for chart labels???

Any ideas? Thanks so much for your help!!
-pb

 

[lbass]

Instead of doing it this way, select stacked bar chart and then set up your date field (on change of year) as your first "on change of" field, and set up your location field (national/regional) as your second on change of field. You can then select the bar->chart options->color Mode: color by series.

-LB

 

[pb100]

Hi lb,
Thanks for the suggestion. The only stumbling block is that I also have a line in the chart showing volume so I'm limited to only 1 OnChgOf field. I'll probably set the values a and b to something meaningful and have them appear in the labels. Have a great day!
-pb