Focal Point
Bar graph

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5141093482

May 16, 2008, 12:51 PM
Michele
Bar graph
I have a horizontal bar graph that displays percentages for five different categories. I was able to change the colors of the actual bars appearing in the bar graph see stylesheet code pasted below. The code pasted below makes the color of the first bar a blue color and the remaining bars a gold color. Does anyone know if I can likewise make the percent value for the first bar a blue color and the percent value for the remaining bars a gold color? Thanks.


W.F version 7.1.7 Windows XP 5.1


DEFMACRO=COND0001,
MACTYPE=RULE,
COLOR='GOLD',
WHEN=N1 NE 1,
$
DEFMACRO=COND0002,
MACTYPE=RULE,
COLOR=RGB(27 138 181),
WHEN=N1 EQ 1,
$
TYPE=DATA,
COLUMN=N3,
MACRO=COND0002,
$
TYPE=DATA,
COLUMN=N3,
MACRO=COND0001,
$
May 20, 2008, 05:40 PM
Kerry
Hi Michele,

I checked with graph expert and was suggested that this may be possible to do. However, can you please provide a little more detail about your request? For example, what text exactly needs to be colored differently? Is it Ordinal Axis labels, Y Axis labels, or data labels?

Also, if you can provide an image, that would clarify it better. Thank you in advance for sharing with all. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
June 02, 2008, 10:44 AM
Michele
Kerry, I am creating an HBAR graph. Pasted below are the set commands that control the colors of the percentages that display alongside each bar for the 5 categories. I would like the first percentage to have the RGB color 27 138 181. I would like the remaining 4 percentages to have the RGB color 232 183 111. Thanks.


Data text color for the first percent

setFillColor(getDataText(),new Color(27 138 181));
setFillType(getColorByHeight(),2);

Data text color for percentages 2-4

setFillColor(getDataText(),new Color(232 183 111));
setFillType(getColorByHeight(),2);

Originally posted by kerry:
Hi Michele,

I checked with graph expert and was suggested that this may be possible to do. However, can you please provide a little more detail about your request? For example, what text exactly needs to be colored differently? Is it Ordinal Axis labels, Y Axis labels, or data labels?

Also, if you can provide an image, that would clarify it better. Thank you in advance for sharing with all. Smiler

Cheers,

Kerry[/QUOTE]