Subscribe Bookmark 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

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} )} )
)
);
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

They're usually near the top of the tree structure.
What do you mean "near the top of the tree structure"?

Just could not get there.
XanGregg

Staff

Joined:

Jun 23, 2011

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.