Dear all,

I use Stata16 and will appreciate any help with creating comparative histogram by the 5-year averages.

I tried a couple of histogram codes that I am familiar with but none could plot the histogram by region and 5-year averages.

Please here is my data:
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input byte r_id str26 region float(period year) double(gfd shr kme klf)
1 "East Asia & Pacific"        1 1  8325.703482570614 221713507.51180354 312545535391.22266  9.884943733931932
1 "East Asia & Pacific"        2 2  9962.102881752555  291994199.0371205  374296140523.1998 10.281044165113197
2 "Europe & Central Asia"      1 1   24102.8204969368   538919571.786615 538401194443.77637 19.022858084454136
2 "Europe & Central Asia"      2 2  25799.98590965781  654494471.3396385  581745338410.1671 23.309416601936224
3 "Latin America & Caribbean"  1 1  9455.280580949593  80081604.26769644  76151826017.24394  6.093767684310448
3 "Latin America & Caribbean"  2 2   9545.11053660585 106220095.91957214  98404982310.05264  7.355575546132802
4 "Middle East & North Africa" 1 1  7373.541711250463   89946551.4761219  81922279949.52919 16.905612650025958
4 "Middle East & North Africa" 2 2 7777.9616878091565  99544773.86252138 106317425321.04172 19.484252374025836
5 "North America"              1 1  49559.27810369779           83961914       2.209272e+11  7.247645902684366
5 "North America"              2 2  53454.28768786681           98022165 270455750000.00006  7.239042277091585
6 "South Asia"                 1 1 1368.5156808676866  12190005.91249332        2.40586e+10  11.19949571592668
6 "South Asia"                 2 2 1780.9751084779448 23091459.198763825        3.49224e+10 10.671254320423737
7 "Sub-Saharan Africa"         1 1  1645.103030610854 38776587.938939884 29995171741.764538 10.925456728424516
7 "Sub-Saharan Africa"         2 2 1682.6993478548713  45598841.52158082  32372205773.37823  10.55520839362721
end
label values year fiveyr
label def fiveyr 1 "2010-2014", modify
label def fiveyr 2 "2015-2019", modify
------------------ copy up to and including the previous line ------------------
Thank you.
Ngozi