Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    plotting multiple graphs from panel data

    ----------------------- copy starting from the next line -----------------------
    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str12 country int year double(totalvat ngdp_ppp hhconsppp) float(vatrate VAT_nominal VAT_C_Efficiency VAT_Productivity) byte cid long countries
"Benin"        2010         0         0         0     0       0       0       0 1 1
"Benin"        2011 1.100e+09 2.300e+10 1.700e+10   .18 25.7602 33.7581 .763081 1 1
"Benin"        2012 1.100e+09 2.400e+10 1.900e+10   .18 25.5074  32.266 .790536 1 1
"Benin"        2013 1.300e+09 2.700e+10 2.000e+10   .18 26.8515 35.8815  .74834 1 1
"Benin"        2014 1.300e+09 2.900e+10 2.200e+10   .18 25.0856 34.3228 .730872 1 1
"Benin"        2015 1.300e+09 3.100e+10 2.300e+10   .18 23.6852 31.7625 .745696 1 1
"Benin"        2016 1.200e+09 3.300e+10 2.400e+10   .18 20.0528 27.6286   .7258 1 1
"Benin"        2017 1.500e+09 3.500e+10 2.500e+10   .18 23.9839 33.5054 .715821 1 1
"Benin"        2018 1.900e+09 3.700e+10 2.600e+10   .18 28.5944  40.754 .701635 1 1
"Benin"        2019 1.800e+09 4.000e+10 2.700e+10   .18 25.3683 37.5766 .675109 1 1
"Benin"        2020 1.900e+09 4.200e+10 2.800e+10   .18 24.6289 37.2777 .660686 1 1
"Benin"        2021 2.200e+09 4.600e+10 3.000e+10   .18  25.896 39.9247  .64862 1 1
"Benin"        2022 2.900e+09 5.300e+10 3.200e+10   .18 30.0746 49.3008 .610022 1 1
"Benin"        2023 3.300e+09 5.800e+10 3.500e+10   .18 31.0696 52.1357 .595937 1 1
"Burkina Faso" 2010 1.100e+09 2.300e+10 1.600e+10   .18  25.211 36.9621 .682076 2 2
"Burkina Faso" 2011 1.200e+09 2.600e+10 1.800e+10   .18 25.4751 37.0766 .687094 2 2
"Burkina Faso" 2012 1.400e+09 2.700e+10 2.000e+10   .18 28.8151 39.2785 .733609 2 2
"Burkina Faso" 2013 1.600e+09 2.900e+10 2.200e+10   .18 31.3402 42.2528  .74173 2 2
"Burkina Faso" 2014 1.400e+09 3.000e+10 2.200e+10   .18  25.682 35.2367 .728842 2 2
"Burkina Faso" 2015 1.600e+09 3.200e+10 2.400e+10   .18 27.2849 36.7826 .741789 2 2
"Burkina Faso" 2016 1.800e+09 3.600e+10 2.600e+10   .18 27.1796 37.6998 .720948 2 2
"Burkina Faso" 2017 2.200e+09 4.100e+10 2.800e+10   .18 29.3964 42.3616 .693938 2 2
"Burkina Faso" 2018 2.400e+09 4.200e+10 2.900e+10   .18 30.8094 45.0907 .683277 2 2
"Burkina Faso" 2019 2.800e+09 4.700e+10 3.000e+10   .18 33.2451 51.0694 .650979 2 2
"Burkina Faso" 2020 2.700e+09 5.100e+10 3.200e+10   .18  28.791 45.9384 .626731 2 2
"Burkina Faso" 2021 2.900e+09 5.500e+10 3.500e+10   .18 29.0313 45.8626 .633007 2 2
"Burkina Faso" 2022 3.200e+09 5.900e+10 3.700e+10   .18 29.9205 48.2132 .620587 2 2
"Burkina Faso" 2023 3.600e+09 6.300e+10 4.000e+10   .18  31.543 49.5161 .637025 2 2
"Gambia"       2010  91000000 4.400e+09 3.800e+09   .15  13.891  16.154 .859912 3 3
"Gambia"       2011  93000000 4.100e+09 3.300e+09   .15 15.1403 18.9544 .798774 3 3
"Gambia"       2012  91000000 4.200e+09 3.200e+09   .15 14.3807 18.7977 .765027 3 3
"Gambia"       2013 1.200e+08 4.200e+09 3.500e+09   .15 19.1071 22.7253 .840784 3 3
"Gambia"       2014 1.400e+08 4.200e+09 3.500e+09   .15 22.5856 26.7658 .843823 3 3
"Gambia"       2015 1.600e+08 4.400e+09 3.600e+09   .15 23.5497 29.3016 .803701 3 3
"Gambia"       2016 1.500e+08 4.600e+09 3.600e+09   .15 22.2779 28.3662 .785367 3 3
"Gambia"       2017 1.500e+08 4.800e+09 4.000e+09   .15 21.2049 25.0125 .847773 3 3
"Gambia"       2018 1.900e+08 5.500e+09 4.800e+09   .15 23.1655 26.5043 .874027 3 3
"Gambia"       2019 2.100e+08 5.900e+09 5.300e+09   .15 23.7207 26.6712 .889375 3 3
"Gambia"       2020 2.300e+08 6.400e+09 5.700e+09   .15 24.4706 27.4467 .891567 3 3
"Gambia"       2021 2.100e+08 7.200e+09 6.200e+09   .15 19.9656 22.9843 .868665 3 3
"Gambia"       2022 2.100e+08 8.000e+09 6.300e+09   .15 17.0314 21.6108 .788098 3 3
"Gambia"       2023 3.200e+08 8.800e+09 6.500e+09   .15 24.0436 32.3223 .743871 3 3
"Ghana"        2010         0         0         0     0       0       0       0 4 4
"Ghana"        2011 3.700e+09 1.100e+11 8.800e+10  .125 26.1708 34.0685 .768182 4 4
"Ghana"        2012 4.300e+09 1.300e+11 1.000e+11  .125 26.0202 33.5113  .77646 4 4
"Ghana"        2013 4.200e+09 1.400e+11 1.000e+11  .125 23.4722 33.1667 .707705 4 4
"Ghana"        2014 5.200e+09 1.500e+11 1.000e+11  .175 19.0219 28.7324 .662036 4 4
"Ghana"        2015 4.500e+09 1.500e+11 1.000e+11  .175 17.2612 25.1322 .686815 4 4
"Ghana"        2016 4.600e+09 1.500e+11 1.100e+11  .175 17.7128 24.7986 .714268 4 4
"Ghana"        2017 5.100e+09 1.600e+11 1.200e+11  .175 18.5969 24.6074 .755743 4 4
"Ghana"        2018 5.400e+09 1.700e+11 1.200e+11   .15 21.3805 30.2881 .705904 4 4
"Ghana"        2019 4.000e+09 1.900e+11 1.300e+11  .125 16.9266 23.5649 .718297 4 4
"Ghana"        2020 3.900e+09 1.900e+11 1.300e+11 .1813 11.1839 15.9814 .699807 4 4
"Ghana"        2021 5.100e+09 2.100e+11 1.500e+11  .125 18.9028 27.8381 .679027 4 4
"Ghana"        2022 5.600e+09 2.400e+11 1.600e+11  .125 18.6484 27.4995 .678137 4 4
"Ghana"        2023 7.600e+09 2.500e+11 1.800e+11   .15 19.9659 28.3817  .70348 4 4
"Mali"         2010 1.300e+09 2.700e+10 1.700e+10   .18 26.8666 42.3158 .634909 5 5
"Mali"         2011 1.300e+09 2.800e+10 1.900e+10   .18 24.8964 36.9562 .673673 5 5
"Mali"         2012 1.100e+09 2.800e+10 2.000e+10   .18 20.7503 28.9238 .717414 5 5
"Mali"         2013 1.200e+09 3.000e+10 2.400e+10   .18 22.4163 28.4231 .788664 5 5
"Mali"         2014 1.300e+09 3.300e+10 2.700e+10   .18 21.4771 26.8052 .801231 5 5
"Mali"         2015 1.500e+09 3.600e+10 2.900e+10   .18  22.719 28.4547 .798427 5 5
"Mali"         2016 1.200e+09 4.100e+10 3.200e+10   .18 15.9697 20.1301 .793325 5 5
"Mali"         2017 2.100e+09 4.300e+10 3.400e+10   .18 26.2747 33.2957 .789132 5 5
"Mali"         2018 1.500e+09 4.600e+10 3.600e+10   .18 17.7568 22.3856 .793223 5 5
"Mali"         2019 2.100e+09 5.000e+10 3.900e+10   .18 23.2708 29.6884 .783836 5 5
"Mali"         2020 2.400e+09 5.000e+10 3.900e+10   .18 26.2727 33.9412 .774065 5 5
"Mali"         2021         0         0         0     0       0       0       0 5 5
"Mali"         2022         0         0         0     0       0       0       0 5 5
"Mali"         2023         0         0         0     0       0       0       0 5 5
"Nigeria"      2010 7.800e+09 7.500e+11 4.700e+11   .05 20.9176 33.0806 .632321 6 6
"Nigeria"      2011 8.300e+09 8.000e+11 5.000e+11   .05 20.7015 33.2657 .622306 6 6
"Nigeria"      2012 8.200e+09 8.300e+11 4.900e+11   .05 19.6738  33.641 .584816 6 6
"Nigeria"      2013 8.900e+09 9.000e+11 6.500e+11   .05 19.8176 27.3464 .724687 6 6
"Nigeria"      2014 8.600e+09 9.700e+11 7.000e+11   .05 17.6821 24.6234 .718101 6 6
"Nigeria"      2015 8.000e+09 9.800e+11 7.900e+11   .05 16.1866 20.2585 .799003 6 6
"Nigeria"      2016 7.900e+09 9.700e+11 8.200e+11   .05 16.2296 19.2503 .843081 6 6
"Nigeria"      2017 8.200e+09 9.900e+11 8.200e+11   .05 16.5338 19.9443 .828999 6 6
"Nigeria"      2018 8.900e+09 1.000e+12 8.100e+11   .05 17.1659 22.0199 .779565 6 6
"Nigeria"      2019 8.800e+09 1.100e+12 8.100e+11   .05 16.3187  21.688 .752432 6 6
"Nigeria"      2020 1.100e+10 1.100e+12 6.600e+11  .075 13.1576 21.4464 .613513 6 6
"Nigeria"      2021 1.400e+10 1.200e+12 6.500e+11  .075 16.2178 28.8098 .562925 6 6
"Nigeria"      2022         0         0         0     0       0       0       0 6 6
"Nigeria"      2023         0         0         0     0       0       0       0 6 6
"Senegal"      2010 2.100e+09 3.400e+10 2.500e+10   .18 33.8533 45.3778 .746033 7 7
"Senegal"      2011 2.400e+09 3.500e+10 2.700e+10   .18 37.4586 48.9025 .765985 7 7
"Senegal"      2012 2.300e+09 3.700e+10 2.900e+10   .18 34.1091 43.1754 .790012 7 7
"Senegal"      2013 2.100e+09 3.800e+10 2.900e+10   .18 30.6299 39.4919 .775601 7 7
"Senegal"      2014 2.500e+09 4.000e+10 3.000e+10   .18 34.7606 46.3371 .750168 7 7
"Senegal"      2015 2.700e+09 4.400e+10 3.200e+10   .18 34.8871 47.5703 .733379 7 7
"Senegal"      2016 2.900e+09 4.700e+10 3.400e+10   .18 34.7104 47.4231 .731929 7 7
"Senegal"      2017 2.700e+09 5.000e+10 3.600e+10   .18 30.0689 41.7716 .719841 7 7
"Senegal"      2018 3.000e+09 5.400e+10 3.800e+10   .18 31.1887 44.0918 .707358 7 7
"Senegal"      2019 3.500e+09 6.000e+10 4.000e+10   .18 32.7813 48.5626 .675031 7 7
"Senegal"      2020 3.300e+09 6.300e+10 4.200e+10   .18 28.6557 43.3649 .660805 7 7
"Senegal"      2021 3.900e+09 7.200e+10 4.500e+10   .18 29.7587  47.694 .623951 7 7
"Senegal"      2022 4.100e+09 8.000e+10 4.900e+10   .18 28.5166 46.2277 .616873 7 7
"Senegal"      2023         0         0         0     0       0       0       0 7 7
"Sierraleone"  2010 1.800e+08 7.300e+09 4.400e+09   .15 16.5906 27.2269 .609345 8 8
"Sierraleone"  2011 2.500e+08 7.900e+09 6.100e+09   .15 20.7555 26.7149 .776928 8 8
end
label values countries country1
label def country1 1 "Benin", modify
label def country1 2 "Burkina Faso", modify
label def country1 3 "Gambia", modify
label def country1 4 "Ghana", modify
label def country1 5 "Mali", modify
label def country1 6 "Nigeria", modify
label def country1 7 "Senegal", modify
label def country1 8 "Sierraleone", modify
    ------------------ copy up to and including the previous line ------------------
    how do i plot a similar bar charts in stata
    Attached Files
    Tags: None
  • #2
    The pdf attachment (deprecated here: FAQ Advice #12) shows two time series as side-by-side bar charts for 9 West African countries (Togo too) and various years.

    A bar chart isn't to my mind the most effective display here. Why not just a line chart?

    Code:
    * Example generated by -dataex-. For more info, type help dataex
clear
input str12 country int year double(totalvat ngdp_ppp hhconsppp) float(vatrate VAT_nominal VAT_C_Efficiency VAT_Productivity) byte cid long countries
"Benin"        2010         0         0         0     0       0       0       0 1 1
"Benin"        2011 1.100e+09 2.300e+10 1.700e+10   .18 25.7602 33.7581 .763081 1 1
"Benin"        2012 1.100e+09 2.400e+10 1.900e+10   .18 25.5074  32.266 .790536 1 1
"Benin"        2013 1.300e+09 2.700e+10 2.000e+10   .18 26.8515 35.8815  .74834 1 1
"Benin"        2014 1.300e+09 2.900e+10 2.200e+10   .18 25.0856 34.3228 .730872 1 1
"Benin"        2015 1.300e+09 3.100e+10 2.300e+10   .18 23.6852 31.7625 .745696 1 1
"Benin"        2016 1.200e+09 3.300e+10 2.400e+10   .18 20.0528 27.6286   .7258 1 1
"Benin"        2017 1.500e+09 3.500e+10 2.500e+10   .18 23.9839 33.5054 .715821 1 1
"Benin"        2018 1.900e+09 3.700e+10 2.600e+10   .18 28.5944  40.754 .701635 1 1
"Benin"        2019 1.800e+09 4.000e+10 2.700e+10   .18 25.3683 37.5766 .675109 1 1
"Benin"        2020 1.900e+09 4.200e+10 2.800e+10   .18 24.6289 37.2777 .660686 1 1
"Benin"        2021 2.200e+09 4.600e+10 3.000e+10   .18  25.896 39.9247  .64862 1 1
"Benin"        2022 2.900e+09 5.300e+10 3.200e+10   .18 30.0746 49.3008 .610022 1 1
"Benin"        2023 3.300e+09 5.800e+10 3.500e+10   .18 31.0696 52.1357 .595937 1 1
"Burkina Faso" 2010 1.100e+09 2.300e+10 1.600e+10   .18  25.211 36.9621 .682076 2 2
"Burkina Faso" 2011 1.200e+09 2.600e+10 1.800e+10   .18 25.4751 37.0766 .687094 2 2
"Burkina Faso" 2012 1.400e+09 2.700e+10 2.000e+10   .18 28.8151 39.2785 .733609 2 2
"Burkina Faso" 2013 1.600e+09 2.900e+10 2.200e+10   .18 31.3402 42.2528  .74173 2 2
"Burkina Faso" 2014 1.400e+09 3.000e+10 2.200e+10   .18  25.682 35.2367 .728842 2 2
"Burkina Faso" 2015 1.600e+09 3.200e+10 2.400e+10   .18 27.2849 36.7826 .741789 2 2
"Burkina Faso" 2016 1.800e+09 3.600e+10 2.600e+10   .18 27.1796 37.6998 .720948 2 2
"Burkina Faso" 2017 2.200e+09 4.100e+10 2.800e+10   .18 29.3964 42.3616 .693938 2 2
"Burkina Faso" 2018 2.400e+09 4.200e+10 2.900e+10   .18 30.8094 45.0907 .683277 2 2
"Burkina Faso" 2019 2.800e+09 4.700e+10 3.000e+10   .18 33.2451 51.0694 .650979 2 2
"Burkina Faso" 2020 2.700e+09 5.100e+10 3.200e+10   .18  28.791 45.9384 .626731 2 2
"Burkina Faso" 2021 2.900e+09 5.500e+10 3.500e+10   .18 29.0313 45.8626 .633007 2 2
"Burkina Faso" 2022 3.200e+09 5.900e+10 3.700e+10   .18 29.9205 48.2132 .620587 2 2
"Burkina Faso" 2023 3.600e+09 6.300e+10 4.000e+10   .18  31.543 49.5161 .637025 2 2
"Gambia"       2010  91000000 4.400e+09 3.800e+09   .15  13.891  16.154 .859912 3 3
"Gambia"       2011  93000000 4.100e+09 3.300e+09   .15 15.1403 18.9544 .798774 3 3
"Gambia"       2012  91000000 4.200e+09 3.200e+09   .15 14.3807 18.7977 .765027 3 3
"Gambia"       2013 1.200e+08 4.200e+09 3.500e+09   .15 19.1071 22.7253 .840784 3 3
"Gambia"       2014 1.400e+08 4.200e+09 3.500e+09   .15 22.5856 26.7658 .843823 3 3
"Gambia"       2015 1.600e+08 4.400e+09 3.600e+09   .15 23.5497 29.3016 .803701 3 3
"Gambia"       2016 1.500e+08 4.600e+09 3.600e+09   .15 22.2779 28.3662 .785367 3 3
"Gambia"       2017 1.500e+08 4.800e+09 4.000e+09   .15 21.2049 25.0125 .847773 3 3
"Gambia"       2018 1.900e+08 5.500e+09 4.800e+09   .15 23.1655 26.5043 .874027 3 3
"Gambia"       2019 2.100e+08 5.900e+09 5.300e+09   .15 23.7207 26.6712 .889375 3 3
"Gambia"       2020 2.300e+08 6.400e+09 5.700e+09   .15 24.4706 27.4467 .891567 3 3
"Gambia"       2021 2.100e+08 7.200e+09 6.200e+09   .15 19.9656 22.9843 .868665 3 3
"Gambia"       2022 2.100e+08 8.000e+09 6.300e+09   .15 17.0314 21.6108 .788098 3 3
"Gambia"       2023 3.200e+08 8.800e+09 6.500e+09   .15 24.0436 32.3223 .743871 3 3
"Ghana"        2010         0         0         0     0       0       0       0 4 4
"Ghana"        2011 3.700e+09 1.100e+11 8.800e+10  .125 26.1708 34.0685 .768182 4 4
"Ghana"        2012 4.300e+09 1.300e+11 1.000e+11  .125 26.0202 33.5113  .77646 4 4
"Ghana"        2013 4.200e+09 1.400e+11 1.000e+11  .125 23.4722 33.1667 .707705 4 4
"Ghana"        2014 5.200e+09 1.500e+11 1.000e+11  .175 19.0219 28.7324 .662036 4 4
"Ghana"        2015 4.500e+09 1.500e+11 1.000e+11  .175 17.2612 25.1322 .686815 4 4
"Ghana"        2016 4.600e+09 1.500e+11 1.100e+11  .175 17.7128 24.7986 .714268 4 4
"Ghana"        2017 5.100e+09 1.600e+11 1.200e+11  .175 18.5969 24.6074 .755743 4 4
"Ghana"        2018 5.400e+09 1.700e+11 1.200e+11   .15 21.3805 30.2881 .705904 4 4
"Ghana"        2019 4.000e+09 1.900e+11 1.300e+11  .125 16.9266 23.5649 .718297 4 4
"Ghana"        2020 3.900e+09 1.900e+11 1.300e+11 .1813 11.1839 15.9814 .699807 4 4
"Ghana"        2021 5.100e+09 2.100e+11 1.500e+11  .125 18.9028 27.8381 .679027 4 4
"Ghana"        2022 5.600e+09 2.400e+11 1.600e+11  .125 18.6484 27.4995 .678137 4 4
"Ghana"        2023 7.600e+09 2.500e+11 1.800e+11   .15 19.9659 28.3817  .70348 4 4
"Mali"         2010 1.300e+09 2.700e+10 1.700e+10   .18 26.8666 42.3158 .634909 5 5
"Mali"         2011 1.300e+09 2.800e+10 1.900e+10   .18 24.8964 36.9562 .673673 5 5
"Mali"         2012 1.100e+09 2.800e+10 2.000e+10   .18 20.7503 28.9238 .717414 5 5
"Mali"         2013 1.200e+09 3.000e+10 2.400e+10   .18 22.4163 28.4231 .788664 5 5
"Mali"         2014 1.300e+09 3.300e+10 2.700e+10   .18 21.4771 26.8052 .801231 5 5
"Mali"         2015 1.500e+09 3.600e+10 2.900e+10   .18  22.719 28.4547 .798427 5 5
"Mali"         2016 1.200e+09 4.100e+10 3.200e+10   .18 15.9697 20.1301 .793325 5 5
"Mali"         2017 2.100e+09 4.300e+10 3.400e+10   .18 26.2747 33.2957 .789132 5 5
"Mali"         2018 1.500e+09 4.600e+10 3.600e+10   .18 17.7568 22.3856 .793223 5 5
"Mali"         2019 2.100e+09 5.000e+10 3.900e+10   .18 23.2708 29.6884 .783836 5 5
"Mali"         2020 2.400e+09 5.000e+10 3.900e+10   .18 26.2727 33.9412 .774065 5 5
"Mali"         2021         0         0         0     0       0       0       0 5 5
"Mali"         2022         0         0         0     0       0       0       0 5 5
"Mali"         2023         0         0         0     0       0       0       0 5 5
"Nigeria"      2010 7.800e+09 7.500e+11 4.700e+11   .05 20.9176 33.0806 .632321 6 6
"Nigeria"      2011 8.300e+09 8.000e+11 5.000e+11   .05 20.7015 33.2657 .622306 6 6
"Nigeria"      2012 8.200e+09 8.300e+11 4.900e+11   .05 19.6738  33.641 .584816 6 6
"Nigeria"      2013 8.900e+09 9.000e+11 6.500e+11   .05 19.8176 27.3464 .724687 6 6
"Nigeria"      2014 8.600e+09 9.700e+11 7.000e+11   .05 17.6821 24.6234 .718101 6 6
"Nigeria"      2015 8.000e+09 9.800e+11 7.900e+11   .05 16.1866 20.2585 .799003 6 6
"Nigeria"      2016 7.900e+09 9.700e+11 8.200e+11   .05 16.2296 19.2503 .843081 6 6
"Nigeria"      2017 8.200e+09 9.900e+11 8.200e+11   .05 16.5338 19.9443 .828999 6 6
"Nigeria"      2018 8.900e+09 1.000e+12 8.100e+11   .05 17.1659 22.0199 .779565 6 6
"Nigeria"      2019 8.800e+09 1.100e+12 8.100e+11   .05 16.3187  21.688 .752432 6 6
"Nigeria"      2020 1.100e+10 1.100e+12 6.600e+11  .075 13.1576 21.4464 .613513 6 6
"Nigeria"      2021 1.400e+10 1.200e+12 6.500e+11  .075 16.2178 28.8098 .562925 6 6
"Nigeria"      2022         0         0         0     0       0       0       0 6 6
"Nigeria"      2023         0         0         0     0       0       0       0 6 6
"Senegal"      2010 2.100e+09 3.400e+10 2.500e+10   .18 33.8533 45.3778 .746033 7 7
"Senegal"      2011 2.400e+09 3.500e+10 2.700e+10   .18 37.4586 48.9025 .765985 7 7
"Senegal"      2012 2.300e+09 3.700e+10 2.900e+10   .18 34.1091 43.1754 .790012 7 7
"Senegal"      2013 2.100e+09 3.800e+10 2.900e+10   .18 30.6299 39.4919 .775601 7 7
"Senegal"      2014 2.500e+09 4.000e+10 3.000e+10   .18 34.7606 46.3371 .750168 7 7
"Senegal"      2015 2.700e+09 4.400e+10 3.200e+10   .18 34.8871 47.5703 .733379 7 7
"Senegal"      2016 2.900e+09 4.700e+10 3.400e+10   .18 34.7104 47.4231 .731929 7 7
"Senegal"      2017 2.700e+09 5.000e+10 3.600e+10   .18 30.0689 41.7716 .719841 7 7
"Senegal"      2018 3.000e+09 5.400e+10 3.800e+10   .18 31.1887 44.0918 .707358 7 7
"Senegal"      2019 3.500e+09 6.000e+10 4.000e+10   .18 32.7813 48.5626 .675031 7 7
"Senegal"      2020 3.300e+09 6.300e+10 4.200e+10   .18 28.6557 43.3649 .660805 7 7
"Senegal"      2021 3.900e+09 7.200e+10 4.500e+10   .18 29.7587  47.694 .623951 7 7
"Senegal"      2022 4.100e+09 8.000e+10 4.900e+10   .18 28.5166 46.2277 .616873 7 7
"Senegal"      2023         0         0         0     0       0       0       0 7 7
"Sierraleone"  2010 1.800e+08 7.300e+09 4.400e+09   .15 16.5906 27.2269 .609345 8 8
"Sierraleone"  2011 2.500e+08 7.900e+09 6.100e+09   .15 20.7555 26.7149 .776928 8 8
end
label values countries country1
label def country1 1 "Benin", modify
label def country1 2 "Burkina Faso", modify
label def country1 3 "Gambia", modify
label def country1 4 "Ghana", modify
label def country1 5 "Mali", modify
label def country1 6 "Nigeria", modify
label def country1 7 "Senegal", modify
label def country1 8 "Sierra Leone", modify

myaxis countries2=countries, sort(mean VAT_C_Efficiency)

set scheme stcolor
line  VAT_C_Efficiency VAT_nominal year, by(countries2, row(2) note("") legend(pos(12))) legend(row(1)) xtitle("")
    Click image for larger version Name: vat.png Views: 1 Size: 60.0 KB ID: 1769169



    Notes on various levels:

    1. Sierra Leone (NB spelling) is truncated in the display only because it is in the data example.

    2. The legend could be improved either directly or by specifying civilised variable labels. Similarly I would add a good ytitle().

    3. I used myaxis from the Stata Journal to sort countries away from alphabetical order. Naturally, there could be a better order depending on your research questions.

    4. With 9 countries I guess you would want a 3 x 3 display.

    5. graph bar or even graph dot could be used but it's hard to avoid an inferior graph, or so I suggest.

    6. You might try plotting the difference too.

    7. On myaxis see https://www.statalist.org/forums/for...e-or-graph-use
    Last edited by Nick Cox; 10 Dec 2024, 08:10.

    Comment

    • #3
      OK thanks

      Comment

      Previous Next
      Working...
      X