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