Graphing

[Clicquot Goldman]

Hello Statalist-ers,

I have a dataset below that I would like to graph - can someone please give me some ideas on whats the best way to plot this information. I want to show the reasons to immigrate has been changing over time. So year of arrival on the X axis and a plot of the reasons?

Also, should I use Excel or State for this particular graph?


Thank you!!!


Year of | Reason to Immigrate
Arrival | Marriage Other School Work | Total
-----------+--------------------------------------------+----------
1975 | 0 0 0 1 | 1
1977 | 1 0 0 0 | 1
1980 | 2 0 2 2 | 6
1981 | 1 0 0 0 | 1
1982 | 0 1 3 2 | 6
1983 | 0 0 1 2 | 3
1984 | 0 0 1 1 | 2
1985 | 1 1 2 2 | 6
1986 | 2 1 0 1 | 4
1987 | 1 0 3 5 | 9
1988 | 2 1 5 1 | 9
1989 | 4 1 3 5 | 13
1990 | 3 1 18 14 | 36
1991 | 2 0 3 3 | 8
1992 | 1 2 2 3 | 8
1993 | 0 0 3 6 | 9
1994 | 0 0 10 9 | 19
1995 | 1 0 10 6 | 17
1996 | 1 0 9 2 | 12
1997 | 3 1 11 4 | 19
1998 | 2 1 6 5 | 14
1999 | 2 0 12 5 | 19
2000 | 6 1 49 28 | 84
2001 | 2 3 13 13 | 31
2002 | 2 0 20 12 | 34
2003 | 0 0 10 15 | 25
2004 | 3 2 14 12 | 31
2005 | 4 0 19 13 | 36
2006 | 2 1 17 8 | 28
2007 | 0 0 27 12 | 39
2008 | 3 1 35 21 | 60
2009 | 4 0 22 10 | 36
2010 | 10 1 52 51 | 114
2011 | 1 0 13 14 | 28
2012 | 5 0 29 27 | 61
2013 | 1 0 11 18 | 30
2014 | 0 0 30 27 | 57
2015 | 2 0 14 23 | 39
2016 | 4 0 11 17 | 32
2017 | 0 0 3 3 | 6
-----------+--------------------------------------------+----------
Total | 78 19 493 403 | 993

[Marcos Almeida]

A bar plot with more than 40 categories (no matter the axis) wouldn´t be friendly enough. Maybe you could aggregate the information by a given time span,

[Nick Cox]

Do please read and act on FAQ Advice #12. A table like that in #1 can't be decoded in terms of your variable names, nor does it correspond to data directly.

This may help. tabplot is from the Stata Journal.

* Example generated by -dataex-. To install: ssc install dataex
clear
input float Year str8 Reason float freq
1975 "Marriage"  0
1975 "Other"     0
1975 "School"    0
1975 "Work"      1
1977 "Marriage"  1
1977 "Other"     0
1977 "School"    0
1977 "Work"      0
1980 "Marriage"  2
1980 "Other"     0
1980 "School"    2
1980 "Work"      2
1981 "Marriage"  1
1981 "Other"     0
1981 "School"    0
1981 "Work"      0
1982 "Marriage"  0
1982 "Other"     1
1982 "School"    3
1982 "Work"      2
1983 "Marriage"  0
1983 "Other"     0
1983 "School"    1
1983 "Work"      2
1984 "Marriage"  0
1984 "Other"     0
1984 "School"    1
1984 "Work"      1
1985 "Marriage"  1
1985 "Other"     1
1985 "School"    2
1985 "Work"      2
1986 "Marriage"  2
1986 "Other"     1
1986 "School"    0
1986 "Work"      1
1987 "Marriage"  1
1987 "Other"     0
1987 "School"    3
1987 "Work"      5
1988 "Marriage"  2
1988 "Other"     1
1988 "School"    5
1988 "Work"      1
1989 "Marriage"  4
1989 "Other"     1
1989 "School"    3
1989 "Work"      5
1990 "Marriage"  3
1990 "Other"     1
1990 "School"   18
1990 "Work"     14
1991 "Marriage"  2
1991 "Other"     0
1991 "School"    3
1991 "Work"      3
1992 "Marriage"  1
1992 "Other"     2
1992 "School"    2
1992 "Work"      3
1993 "Marriage"  0
1993 "Other"     0
1993 "School"    3
1993 "Work"      6
1994 "Marriage"  0
1994 "Other"     0
1994 "School"   10
1994 "Work"      9
1995 "Marriage"  1
1995 "Other"     0
1995 "School"   10
1995 "Work"      6
1996 "Marriage"  1
1996 "Other"     0
1996 "School"    9
1996 "Work"      2
1997 "Marriage"  3
1997 "Other"     1
1997 "School"   11
1997 "Work"      4
1998 "Marriage"  2
1998 "Other"     1
1998 "School"    6
1998 "Work"      5
1999 "Marriage"  2
1999 "Other"     0
1999 "School"   12
1999 "Work"      5
2000 "Marriage"  6
2000 "Other"     1
2000 "School"   49
2000 "Work"     28
2001 "Marriage"  2
2001 "Other"     3
2001 "School"   13
2001 "Work"     13
2002 "Marriage"  2
2002 "Other"     0
2002 "School"   20
2002 "Work"     12
2003 "Marriage"  0
2003 "Other"     0
2003 "School"   10
2003 "Work"     15
2004 "Marriage"  3
2004 "Other"     2
2004 "School"   14
2004 "Work"     12
2005 "Marriage"  4
2005 "Other"     0
2005 "School"   19
2005 "Work"     13
2006 "Marriage"  2
2006 "Other"     1
2006 "School"   17
2006 "Work"      8
2007 "Marriage"  0
2007 "Other"     0
2007 "School"   27
2007 "Work"     12
2008 "Marriage"  3
2008 "Other"     1
2008 "School"   35
2008 "Work"     21
2009 "Marriage"  4
2009 "Other"     0
2009 "School"   22
2009 "Work"     10
2010 "Marriage" 10
2010 "Other"     1
2010 "School"   52
2010 "Work"     51
2011 "Marriage"  1
2011 "Other"     0
2011 "School"   13
2011 "Work"     14
2012 "Marriage"  5
2012 "Other"     0
2012 "School"   29
2012 "Work"     27
2013 "Marriage"  1
2013 "Other"     0
2013 "School"   11
2013 "Work"     18
2014 "Marriage"  0
2014 "Other"     0
2014 "School"   30
2014 "Work"     27
2015 "Marriage"  2
2015 "Other"     0
2015 "School"   14
2015 "Work"     23
2016 "Marriage"  4
2016 "Other"     0
2016 "School"   11
2016 "Work"     17
2017 "Marriage"  0
2017 "Other"     0
2017 "School"    3
2017 "Work"      3
end

tabplot Reason Year [fw=freq] , xla(, ang(v) labsize(small) format(%tyY)) xasis barw(1) bfcolor(none) showval(mlabsize(small)) xsize(8) subtitle("")

.

[Marcos Almeida]

Nick Cox kudos to tabplot. Amassing such an amount of information under a single graph is really remarkable.