Hey there Stata-heads,
I have cross-national data from 1970-2020 and want to make a bar graph in which I plot the mean value of GDP growth rate and industrial value-added by five year blocks of time for all countries. Doing this for one variable is easy but two is confusing to me. In addition, I would also like to add a line graph on a second axis for the variable greenhouse gas (GHG) emissions.
I have in mind something like this:
And here is a stripped down version of my data:
I have cross-national data from 1970-2020 and want to make a bar graph in which I plot the mean value of GDP growth rate and industrial value-added by five year blocks of time for all countries. Doing this for one variable is easy but two is confusing to me. In addition, I would also like to add a line graph on a second axis for the variable greenhouse gas (GHG) emissions.
I have in mind something like this:
And here is a stripped down version of my data:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str55 country str9 ISO double(year GDP_growth ind_VA PIK_GHG_Total) "United Arab Emirates" "ARE" 1970 . . 41.7 "United Arab Emirates" "ARE" 1971 . . 56.5 "United Arab Emirates" "ARE" 1972 . . 62.1 "United Arab Emirates" "ARE" 1973 . . 80.6 "United Arab Emirates" "ARE" 1974 . . 81.4 "United Arab Emirates" "ARE" 1975 . 73.99550700529899 80.1 "United Arab Emirates" "ARE" 1976 16.52685650601475 71.8147226501297 99.5 "United Arab Emirates" "ARE" 1977 21.43933017019894 67.98170618652273 93.1 "United Arab Emirates" "ARE" 1978 -1.589603319915952 68.05879988266099 107 "United Arab Emirates" "ARE" 1979 20.92357307701521 71.35555238486911 73.1 "United Arab Emirates" "ARE" 1980 23.87477491049799 72.66360633019463 71.8 "United Arab Emirates" "ARE" 1981 4.659176674065151 68.36330706835336 60.3 "United Arab Emirates" "ARE" 1982 -6.719316185707839 63.15205197718987 57 "United Arab Emirates" "ARE" 1983 -4.745820699965805 61.40417867893668 55.1 "United Arab Emirates" "ARE" 1984 4.016951279594096 62.81071430898441 72.3 "United Arab Emirates" "ARE" 1985 -3.594476517368378 61.25214684413911 72.6 "United Arab Emirates" "ARE" 1986 -14.95813656453269 52.15437334981181 62.6 "United Arab Emirates" "ARE" 1987 3.381981709008784 54.68110115371082 59.4 "United Arab Emirates" "ARE" 1988 -2.618907703832789 53.01423765469182 56.8 "United Arab Emirates" "ARE" 1989 12.33789128226005 55.07692920679552 62.1 "United Arab Emirates" "ARE" 1990 18.32798553364054 58.90235057085292 61.2 "United Arab Emirates" "ARE" 1991 .8600819457782194 46.77830148799459 67.2 "United Arab Emirates" "ARE" 1992 3.344944861841199 55.29802322311062 68.9 "United Arab Emirates" "ARE" 1993 1.261190951497241 51.47992164544564 76.3 "United Arab Emirates" "ARE" 1994 6.896148550526675 46.26037508784663 83.2 "United Arab Emirates" "ARE" 1995 6.68788646362944 45.54517392115022 84.8 "United Arab Emirates" "ARE" 1996 5.798404061321591 46.36700236966825 77.5 "United Arab Emirates" "ARE" 1997 8.190398640770496 45.42841150170342 81.3 "United Arab Emirates" "ARE" 1998 .2919943486854351 40.02353245968177 103 "United Arab Emirates" "ARE" 1999 2.902213644645983 42.02066256940727 104 "United Arab Emirates" "ARE" 2000 10.85270421259857 48.51701163163952 138 "United Arab Emirates" "ARE" 2001 1.399085030326304 49.6763412859899 136 "United Arab Emirates" "ARE" 2002 2.433456810361562 47.54574758244483 126 "United Arab Emirates" "ARE" 2003 8.80054081486432 49.12101291546045 157 "United Arab Emirates" "ARE" 2004 9.566436637161615 51.67834808476933 171 "United Arab Emirates" "ARE" 2005 4.855141196309049 55.64347630248069 183 "United Arab Emirates" "ARE" 2006 9.837319773484893 57.90311171807097 186 "United Arab Emirates" "ARE" 2007 3.184390173672398 54.84022859025103 193 "United Arab Emirates" "ARE" 2008 3.191836276103842 58.01797844355845 212 "United Arab Emirates" "ARE" 2009 -5.242921906675903 52.04495600036804 215 "United Arab Emirates" "ARE" 2010 1.60285004831249 52.53086183458973 205 "United Arab Emirates" "ARE" 2011 6.928508594569678 58.03559960682533 206 "United Arab Emirates" "ARE" 2012 4.77662573667088 56.56806174025645 212 "United Arab Emirates" "ARE" 2013 5.055559654259881 54.20381497824792 205 "United Arab Emirates" "ARE" 2014 4.165691842561785 51.98971366796552 235 "United Arab Emirates" "ARE" 2015 6.786772879452158 43.35424493048169 253 "United Arab Emirates" "ARE" 2016 5.561490754967991 41.02857173119335 262 "United Arab Emirates" "ARE" 2017 .7350687131656457 42.52803476546636 266 "United Arab Emirates" "ARE" 2018 1.313913881411182 46.91895758989315 271 "United Arab Emirates" "ARE" 2019 1.108348138930992 44.52451604011626 . "United Arab Emirates" "ARE" 2020 -4.957052436527391 42.17404307290148 . "Argentina" "ARG" 1970 3.045643319171148 42.27878963445896 200 "Argentina" "ARG" 1971 5.658131081849248 45.95472845323295 204 "Argentina" "ARG" 1972 1.628416518259385 45.58164895074697 212 "Argentina" "ARG" 1973 2.811754038490349 43.35223993379024 218 "Argentina" "ARG" 1974 5.533804395773601 43.59280262399284 220 "Argentina" "ARG" 1975 -.0284121037110907 50.14132367847201 223 "Argentina" "ARG" 1976 -2.018251516833942 50.89369682994164 232 "Argentina" "ARG" 1977 6.93414775653342 47.80613219324592 234 "Argentina" "ARG" 1978 -4.506124802013588 46.09764801288574 234 "Argentina" "ARG" 1979 10.22276346386812 44.02812379702785 241 "Argentina" "ARG" 1980 1.518783949901788 41.21966566689963 236 "Argentina" "ARG" 1981 -5.189789141355931 40.33822670725763 227 "Argentina" "ARG" 1982 -.7356591591036192 41.10284864431987 226 "Argentina" "ARG" 1983 4.349093279267564 41.55630651201022 229 "Argentina" "ARG" 1984 1.570738701820233 39.70818793304001 231 "Argentina" "ARG" 1985 -5.189024353439038 39.27615457115928 224 "Argentina" "ARG" 1986 6.153377062756931 37.38043489147745 228 "Argentina" "ARG" 1987 2.704868827705582 37.82867526990481 236 "Argentina" "ARG" 1988 -1.089933341337911 38.48661108209829 242 "Argentina" "ARG" 1989 -7.156949655979531 42.34781306958608 238 "Argentina" "ARG" 1990 -2.467213778104721 36.02188134781353 236 "Argentina" "ARG" 1991 9.133110567389608 32.72252825563223 242 "Argentina" "ARG" 1992 7.937291556430765 30.68395490221141 248 "Argentina" "ARG" 1993 8.206979072212278 27.33873964586097 250 "Argentina" "ARG" 1994 5.836200703685265 26.75455869328776 253 "Argentina" "ARG" 1995 -2.845209610570791 26.30121033554979 254 "Argentina" "ARG" 1996 5.526689827152339 26.59256063986831 267 "Argentina" "ARG" 1997 8.111046770745702 27.17915088831144 267 "Argentina" "ARG" 1998 3.850178851562276 26.71213576262781 274 "Argentina" "ARG" 1999 -3.385457040632687 26.19363049911295 279 "Argentina" "ARG" 2000 -.7889989390569099 25.99083601113638 283 "Argentina" "ARG" 2001 -4.408839682585565 25.24343398273332 284 "Argentina" "ARG" 2002 -10.89448482859028 30.55773709130463 274 "Argentina" "ARG" 2003 8.83704079576924 32.64509909965032 290 "Argentina" "ARG" 2004 9.02957330068152 28.81692200683402 298 "Argentina" "ARG" 2005 8.851659920134367 28.62631404390839 305 "Argentina" "ARG" 2006 8.047151500430274 29.2032796652469 316 "Argentina" "ARG" 2007 9.007650875047574 27.41523613347833 331 "Argentina" "ARG" 2008 4.057233103464057 26.27245993959456 331 "Argentina" "ARG" 2009 -5.918525076349468 25.28420479937347 308 "Argentina" "ARG" 2010 10.12539815610023 25.25877625767221 320 "Argentina" "ARG" 2011 6.003951692805785 25.21269760588435 330 "Argentina" "ARG" 2012 -1.026420454432099 24.42905706491223 333 "Argentina" "ARG" 2013 2.405323780794362 24.00588144230719 342 "Argentina" "ARG" 2014 -2.512615320813936 24.27739449366017 343 "Argentina" "ARG" 2015 2.731159828289435 23.15305613590499 350 "Argentina" "ARG" 2016 -2.080327843778107 22.05410721121083 352 "Argentina" "ARG" 2017 2.818502977759181 21.78212321933503 351 "Argentina" "ARG" 2018 -2.617396462820381 23.71959233213043 351 end
