Graph Labels and Data Values Format

August 15, 2011, 10:35 AM

I have a graph report that is running but the x and y axis labels and data values on top of each bars are too bold(style). I don't seem to get how to control the formating of these values and labels. I wanted to change them to Arial and normal instead of bold.

Please, any suggestion on how this can be done?

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

August 18, 2011, 02:08 PM

Kerry

Hi umun,

I checked with our graph people and was suggested that the following document may be of help:

http://techsupport.information...om/sps/61022539.html

Cheers,

Kerry

August 19, 2011, 08:34 AM

umun

quote:
Originally posted by Kerry:
Hi umun,

I checked with our graph people and was suggested that the following document may be of help:

http://techsupport.information...om/sps/61022539.html

Cheers,

Kerry

No document for me to access in the link you provided. Please, can you show me an example?

Thanks

August 22, 2011, 02:12 PM

Kerry

From the document:

Problem:
How to make the font for the X axis, Y axis and datatext the same size and the same style in a waterfall graph.

Solution:
The following stylesheet command will change the style of each component:
setFontStyle(getXXXXXXX(),0);
Where XXXXXX is either the X axis, Y axis or datatext.

The possible styles are listed below:
0 = Plain
1 = Italic
2 = Bold
3 = Italic/Bold
4 = Underline
5 = Italic/Underline
6 = Bold/Underline
7 = Bold/Italic/Underline

The code below will change the size of your font:
setFontSizeAbsolute(getO1Label(0),true);
setFontSize(getO1Label(0),12);

August 23, 2011, 12:21 AM

paullopez

Hey Kerry, This is nice stuff even i want this from long. Thanx for giving the example to explain it!!

September 01, 2011, 09:20 AM

umun

Thanks Kerry. I still have one question though.

I want to make the datavalues to have 2 decimal places. Currently, a value of 0.2301% is being shown as 0%. Please, any hint on how I can make the datavalue to be like 0.23% instead of 0%.

Thank you.

September 01, 2011, 11:00 AM

Doug

Try "setFontStyle(getXXXXXXX(),0.00);" If not, 1) what is the format of the field showing as "0"?, and 2) please post your code.

September 02, 2011, 06:03 AM

umun

I am graphing from a hold file. The format in the hold file (which gets re-created whenever the report is run , I guess) is:

USAGE=D19S, ACTUAL=D08

September 02, 2011, 06:18 AM

umun

quote:
Originally posted by Kerry:
From the document:

Problem:
How to make the font for the X axis, Y axis and datatext the same size and the same style in a waterfall graph.

Solution:
The following stylesheet command will change the style of each component:
setFontStyle(getXXXXXXX(),0);
Where XXXXXX is either the X axis, Y axis or datatext.

The possible styles are listed below:
0 = Plain
1 = Italic
2 = Bold
3 = Italic/Bold
4 = Underline
5 = Italic/Underline
6 = Bold/Underline
7 = Bold/Italic/Underline

The code below will change the size of your font:
setFontSizeAbsolute(getO1Label(0),true);
setFontSize(getO1Label(0),12);

Please, how can I make the datatext have 2 decimal places like 0.23%

Thanks