Bar chart from non-normalised data table

zurvy

Hi all,

I'm new to JMP and are trying to understand the basics of JMP.

When trying to create a bar chart, I understand that the underlying data should be normalised in nature (with normalise I mean not summarised/cross tabled).

Situation:

1) Assume the following data table, representing the time/period of employees active in a company with a given education ;

Period	None	AA	BA	MA	PhD
<1 Year	10	3	50	20	12
1-5 Years	42	9	112	27	15
>5 Years	112	30	63	5	2

2) My goal is to create the following stacked bar chart (see attached file).

In order to create the bar chart, I had to normalise the data from the table as follows;

Period	Education	Frequency
<1 Year	None	10
1-5 Years	None	42
>5 Years	None	112
<1 Year	AA	3
1-5 Years	AA	9
>5 Years	AA	30
<1 Year	BA	50
1-5 Years	BA	112
>5 Years	BA	63
<1 Year	MA	20
1-5 Years	MA	27
>5 Years	MA	5
<1 Year	PhD	12
1-5 Years	PhD	15
>5 Years	PhD	2

==> Question;

Is there a way to normalise the data in JMP? If so, could anyone point me in the right question? If not, can the stack bar chart be created with the original table (non-normalised one)?

Thanks for the help!

Stack_BChart.jpg

zurvy

Hi All,

I think I just figured it out...

For the members trying to do the same thing;

1) Open the data table in JMP (I used V11)

2) On the Top-Left, press on the red triangle left to the data set name

3) Tables --> Stack

4) Select all the columns containing the frequency ( in my case [None, AA, BA, MA, PhD])

5) Press OK

The script for it is;

Data Table( "YourNewTableName" ) << Stack(

  columns( :None, :AA, :BA, :MA, :PhD ),

  Source Label Column( "Education" ),

  Stacked Data Column( "Frequency" )

)