Graph from Stata to Excel

[Franziska Rahm]

hello! which command can I use to export a graph from stata to excel?
someone could write this directly around the command:

graph bar, over(hochschule_haw, label(angle(vertical)labsize(vsmall)))

and do I have to pay attention to anything? Activate before or so?

Greetings and thanks, Franzi

[Justin Niakamal]

You can use putexcel to export a graph from Stata to Excel. See, "Example 5: Adding a graph to an Excel file" in the Stata Blog post below:

https://blog.stata.com/2017/01/24/cr...a-expressions/

[Franziska Rahm]

Thanks a lot !!!
And what do I write in the parenthesis of "sheet (...)"?

sorry, sorry, I am a total beginner...

[Justin Niakamal]

No problem. You can just use that to name the sheet. For example sheet("hochschule_haw graph") if you have a spreadsheet with multiple sheets. Otherwise, you can ignore and by default sheet1 will be used.

clear all
sysuse "auto.dta"

putexcel set myexample.xlsx,  replace
scatter price mpg 
graph export my_scatter.png, replace
putexcel A1 = picture(my_scatter.png)

[Franziska Rahm]

thanks a lot, it works!
Can i also adjust the size of the image? In stata as command, so that it is smaller in ecxel?

[Franziska Rahm]

and how can I place the graph at a certain position in excel?

[Justin Niakamal]

You can place the graph in a certain position when you specify putexcel cellexplist. For example, putexcel D1 means write in Excel column D row 1. As for adjusting the size, you can use the width() and height() options in graph export.

clear all
sysuse "auto.dta"

putexcel set myexample.xlsx,  replace
scatter price mpg 
graph export my_scatter.png, width(100) height(100) replace 
putexcel D1 = picture(my_scatter.png)

Note (from the help file)

width(#) specifies the width of the graph in pixels. width() must contain an integer between 8 and 16,000.
height(#) specifies the height of the graph in pixels. height() must contain an integer between 8 and 16,000.

Hope this helps.

[Franziska Rahm]

Thank you so much ! It's working (: