I am trying to graph the mean and min/max values that correspond to categorical data (names) as in the png file below. So far I have used the following code - a twoway rcap and scatter:
twoway rcap max_daysPIF3 min_daysPIF3 RTA2 if TechTeam=="LECRDS", lcolor(yellow) yscale(range(0 800)) || ///
scatter mean_daysPIF3 RTA2 if TechTeam=="LECRDS", mcolor(red) ///
graphregion(fcolor(black)) plotr(fcolor(black) lcolor(black)) ///
ylabel(, angle(horz)labsize(small) labcolor(white)) ///
xlabel(1 "Anna Kaplina" 2 "Benjamin Larroquette" 3 "Claudia Ortiz" 4 "Gabor Vereczi" 5 "Henry Diouf" ///
6 "Keti Chachibaia" 7 "Mame Diop" 8 "Pradeep Kurukulasuriya" 9 "Reis Lopez Rello" 10 "Stephen Gold" ///
11 "Tom Twining-Ward" 12 "Yusuke Taishi", angle(45) labsize(vsmall) labcolor(white)) ///
xtitle("RTA - LECRDS Team", size(small) margin (medium) color(white)) ///
ytitle("Number of Days", size(small) margin (medium) color(white)) ///
title("Mean Number of Days from PIF Submission to Approval", size(medium) color(white)) ///
legend(pos(12) size(small) color(white) fcolor(black) lcolor(black) region(fcolor(black)) ///
label(1 "Max/Min Days") label(2 "Mean Days"))
I need the x label names (RTA2) to match the data and without any odd spaces in between.
Also, a horizontal twoway graph would be ideal if possible.
twoway rcap max_daysPIF3 min_daysPIF3 RTA2 if TechTeam=="LECRDS", lcolor(yellow) yscale(range(0 800)) || ///
scatter mean_daysPIF3 RTA2 if TechTeam=="LECRDS", mcolor(red) ///
graphregion(fcolor(black)) plotr(fcolor(black) lcolor(black)) ///
ylabel(, angle(horz)labsize(small) labcolor(white)) ///
xlabel(1 "Anna Kaplina" 2 "Benjamin Larroquette" 3 "Claudia Ortiz" 4 "Gabor Vereczi" 5 "Henry Diouf" ///
6 "Keti Chachibaia" 7 "Mame Diop" 8 "Pradeep Kurukulasuriya" 9 "Reis Lopez Rello" 10 "Stephen Gold" ///
11 "Tom Twining-Ward" 12 "Yusuke Taishi", angle(45) labsize(vsmall) labcolor(white)) ///
xtitle("RTA - LECRDS Team", size(small) margin (medium) color(white)) ///
ytitle("Number of Days", size(small) margin (medium) color(white)) ///
title("Mean Number of Days from PIF Submission to Approval", size(medium) color(white)) ///
legend(pos(12) size(small) color(white) fcolor(black) lcolor(black) region(fcolor(black)) ///
label(1 "Max/Min Days") label(2 "Mean Days"))
I need the x label names (RTA2) to match the data and without any odd spaces in between.
Also, a horizontal twoway graph would be ideal if possible.
Comment