One quick way to get close to what you want: Format the Table
Column in JMP as Currency 14.0. Then run your code.
From:
jmp-l-owner@lists.biostat.wustl.edu
[mailto:jmp-l-owner@lists.biostat.wustl.edu] On Behalf Of Fred Zhang
Sent: Monday, March 02, 2009 1:47 PM
To: jmp-l@lists.biostat.wustl.edu
Subject: [jmp-l] Why I cannot control the axis setting by JSL?
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.
------------------------------------------------------
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)})
)
);
|
|