![\"\"](\"http:\/\/blog.uvm.edu\/tbplante\/files\/2018\/03\/stacked-bar-graph-stata.jpg\")
<\/figure><\/p>\n<\/div><\/div>\n\n\n\n
Start with an Excel file<\/h2>\n\n\n\n
I made an Excel file called\u00a0stacked bar graph data.xlsx\u00a0<\/strong><\/em>that I saved in the same folder as a .do file. I closed Stata and reopened that .do file from Windows explorer so that Stata set the working directory as the same folder that contains the .do file. More importantly, it set the working directory as the same folder that also\u00a0<\/em>contains\u00a0the Excel file.<\/p>\n\n\n\n Group<\/em> is the number of the individual bars, bottom<\/em> is the bottom of the first segment of a bar, q1<\/em> is the top of the first segment of each bar. The rest should be obvious. I made this for quartiles, hence the q1-4 names. You can tweak the numbers by editing the Excel file, hitting save\/close, and rerunning the .do file.<\/p>\n\n\n\n Make sure that you save and close Excel before running the .do file or the .do file won’t run and you will be sad.\u00a0<\/strong><\/em><\/p>\n\n\n\n Here’s my code! I hope it’s useful.<\/p>\n\n\n Making a horizontal stacked bar graph in Stata I spent a bit of time making a variation of this figure today. (The data here are made up.) I’m pleased with how it came out. I first tried to use the -graph bar, horizontal- command, but it didn’t give me as much customization as -twoway graph … Continue reading Making a horizontal stacked bar graph with -graph twoway rbar- in Stata<\/span><\/a><\/p>\n","protected":false},"author":4473,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[477491],"tags":[],"class_list":["post-196","post","type-post","status-publish","format-standard","hentry","category-stata-code"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts\/196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/users\/4473"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":9,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"predecessor-version":[{"id":562,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/posts\/196\/revisions\/562"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/tbplante\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"http:\/\/blog.uvm.edu\/tbplante\/files\/2018\/03\/excel-dataset-for-stacked-bar.jpg\")
<\/figure>\n\n\n\nMy .do file for making this horizontal stacked bar graph<\/h2>\n\n\n\n
********************************************************************************\n******************************IMPORT DATA HERE**********************************\n********************************************************************************\nimport excel \"stacked bar graph data.xlsx\", firstrow clear \/\/ make sure that excel\n\/\/ is closed before you\n\/\/ run this script!\ndestring, replace\n\n********************************************************************************\n******************************CODE STARTS HERE**********************************\n********************************************************************************\ncapture ssc install scheme-burd, replace \/\/ this installs nicer color schemes\n\/\/ see the schemes here: https:\/\/github.com\/briatte\/burd\nset scheme burd4 \n\ngraph twoway \/\/\/\n(rbar bottom q1 group, horizontal) \/\/\/\n(rbar q1 q2 group, horizontal) \/\/\/\n(rbar q2 q3 group, horizontal) \/\/\/\n(rbar q3 q4 group, horizontal) \/\/\/\n, \/\/\/ if you modify this file and it stops working, check the placement of this comma\nxscale(log) \/\/\/ make the x axis log scale\nxla(0.25 \"0.25\" 0.5 \"0.5\" 1 \"1\" 2.5 \"2.5\" 5 \"5\" 10 \"10\" 25 \"25\" 50 \"50\" 100 \"100\") \/\/\/\nyla(1 \"Group 1\" 2 \"Group 2\" 3 \"Group 3\" 4 \"Group 4\") \/\/\/\nytitle(\"Y title\") \/\/\/\nxtitle(\"X title\") \/\/\/\ntext(4 1.2 \"Q1\", color(white)) \/\/\/ first number is y second is x.\ntext(4 4.3 \"Q2\", color(white)) \/\/\/\ntext(4 20 \"Q3\", color(white)) \/\/\/\ntext(4 90 \"Q4\", color(white)) \/\/\/\nlegend(off) \/\/\/ no legend, aspect is the shape of the figure. 1 is tall and thin.\naspect(.25) \n\/\/\n\/\/ export the graph as a PNG file\ngraph export \"stacked graph.png\", replace width(2000)\n\/\/ graph export \"stacked graph.tif\", replace width(2000) \/\/ in case you want as a tiff\n\n<\/pre>","protected":false},"excerpt":{"rendered":"