How JSL make charts like excel? Could you share the script?
Table will attach below:
| Area | C | #N/A | Grtal | Ops Cert Rate | Q1 Goal |
| 530s Cel | 12 | 3 | 15 | 80% | 90% |
| 830s M | 6 | 4 | 10 | 60% | 90% |
| 14PI | 15 | 5 | 20 | 75% | 90% |
| CM | 15 | | 15 | 100% | 90% |
| DF | 17 | 1 | 18 | 94% | 90% |
| Drh | 14 | 6 | 20 | 70% | 90% |
| Ttro Area | 10 | 1 | 11 | 91% | 90% |
| DA | 8 | 3 | 11 | 73% | 90% |
| PIch | 2 | 5 | 7 | 29% | 90% |
| R | 7 | | 7 | 100% | 90% |
| TF | 16 | 3 | 19 | 84% | 90% |
| T | 11 | 2 | 13 | 85% | 90% |
| W | 13 | | 13 | 100% | 90% |
| Yie Area | 6 | | 6 | 100% | 90% |
| Grand Total | 152 | 33 | 185 | 82% | 90% |
Hi @Theresa,
If you are asking about the value ordering column property it can be accessed by
right-clicking the header area of the Area column, then select Column Properties, and select the property.
Or if you are asking how did I select the Graph Builder platform?
That can be accessed from the graph menu and then select graph builder.
Otherwise feel free to continue to ask additional questions until you get the information you seek.
cheers,
Stan
Hi @Theresa
I have included a script in the data table to create a similar graph using JMP.
I created the graph interactively and then saved the script to the data table.
To keep the bars in the same order as they appear in the data table you can uncheck the custom order and keep the row order levels checked when using the value order column property.
To make the reference line appear "in-front" of the bars I right-clicked on the graph and chose customize.
Right-Click to customize draw orderRight-Click to customize draw order
Use the up or down arrow to move the reference line to the bottom so it will be drawn last.
use up or down arrow to change the draw orderuse up or down arrow to change the draw order
And for anyone following along that would like to see the JSL
Graph Builder(
Size( 961, 673 ),
Show Control Panel( 0 ),
Variables(
X( :Area ),
Y( :Ops Cert Rate, Side( "Right" ) ),
Y( :Ops Cert Rate, Position( 1 ) )
),
Elements(
Bar( X, Y( 2 ), Legend( 4 ), Label( "Label by Value" ) ),
Bar( X, Y( 1 ), Legend( 6 ), Label( "Label by Value" ) )
),
SendToReport(
Dispatch(
{},
"Ops Cert Rate",
ScaleBox,
{Add Ref Line( 0.9, "Solid", "Medium Dark Red", "Q1 Goal", 2 )}
),
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
4,
Properties( 0, {Fill Color( 37 )}, Item ID( "Ops Cert Rate", 1 ) )
), Legend Model(
6,
Properties( 0, {Fill Color( 37 )}, Item ID( "Ops Cert Rate", 1 ) )
)}
),
Dispatch( {}, "graph title", TextEditBox, {Set Text( "Rate" )} ),
Dispatch( {}, "Y title", TextEditBox, {Set Text( "" )} ),
Dispatch( {}, "Y r title", TextEditBox, {Set Text( "" )} ),
Dispatch(
{},
"Graph Builder",
FrameBox,
{Grid Line Order( 1 ), Reference Line Order( 4 )}
),
Dispatch(
{},
"400",
LegendBox,
{Legend Position( {4, [-1], 6, [0]} ), Position( {-1, 0} )}
)
)
)
JMP Graph Builder Bar ChartJMP Graph Builder Bar Chart
