BookmarkSubscribeSubscribe to RSS Feed

Why I cannot control the axis setting by JSL?

Hi, all

I am using Graph Builder to generate a plot.
Attached is the data file, and following is the code.

I need to change the x-axis format to be USD Currency 14.0,
and also try to show the major grid of y-axis.
However, the code did not work as the way I expect, that is, both AxisBox do not change at all.

Please advise me what's wrong with my code.

Thank you so much.
Fred
------------------------------------------------------
dt = data table("Graph Example Data");
biv = Graph Builder(Size(670, 460), Show Control Panel( 0 ),
Variables( X( :Margin, Format("Currency", "USD", 14,0)), Y( :NP, Size(94))),
Elements(Bar(X, Y, Legend( 10 ), Bar Style( "Side by side" ),
Summary Statistic( "Mean" ))),
SendToReport(Dispatch( {}, "400", LegendBox, {Set Title( "" ), Position( {-1} )}),
Dispatch({}, AxisBox(2), {Scale("Linear"), Format("Best"), Min(-0.5), Max(9.5), Inc(1), Minor Ticks(0), Show Major Grid(1),
Show Major Ticks(1), Show Minor Grid(0), Show Minor Ticks(1), Show Labels(1), Rotated Labels(0)}),
Dispatch({}, AxisBox(1), {Scale("Linear"), Format("Currency", "USD", 14, 0), Min(-3802.28136882129), Max(1996197.71863118), Inc(500000), Minor Ticks(1), Show Major Grid(0), Show Major Ticks(1), Show Minor Grid(0), Show Minor Ticks(1), Show Labels(1), Rotated Labels(0)})
)
-----------------------------------------------------------------------------------
Data file:
NP Margin
(001) FGNSC $1,739,795
(002) TTSG684 $1,025,412
(003) FSQ0765R $781,012
(004) A2005 $730,283
(005) SG68 $630,476
(006) B6105A $624,047
(007) CT504SG $599,332
(008) FSBF5CH60BS $597,523
(009) SPF1SS $589,135
(010) AS7371 $570,097
5 REPLIES
XanGregg

Staff

Joined:

Jun 23, 2011

Re: Why I cannot control the axis setting by JSL?

I’m having success with

Graph Builder(
Size( 670, 460 ),
Show Control Panel( 0 ),
Variables( X( :Margin ), Y( :NP, Size( 94 ) ) ),
Elements(
Bar(
X,
Y,
Legend( 10 ),
Bar Style( "Side by side" ),
Summary Statistic( "Mean" )
)
),
SendToReport(
Dispatch(
{},
"Margin",
ScaleBox,
{Format( "Currency", "USD", 14, 0 ), Show Major Grid( 1 )}
),
Dispatch( {}, "400", LegendBox, {Set Title( "" ), Position( {-1} )} )
)
);

Re: Why I cannot control the axis setting by JSL?

Thanks a lot, Xan.

By viewing this graph's tree structure, I can only see AxisBox(1) and AxisBox(2) for the axis.
How or where can you find the "ScaleBox"?
XanGregg

Staff

Joined:

Jun 23, 2011

Re: Why I cannot control the axis setting by JSL?

They're usually near the top of the tree structure.

Re: Why I cannot control the axis setting by JSL?

What do you mean "near the top of the tree structure"?

Just could not get there.
XanGregg

Staff

Joined:

Jun 23, 2011

Re: Why I cannot control the axis setting by JSL?

I thought you were looking that the "Show Tree Structure" window. I forget the key combination to get to it, but the manual will have it.