I have data on multiple worksheets and want to draw scatter plots.
x-values contains data on countries' variables in year 2004-2008
y-values contains data on countries' FDI receipts in year 2004-2008
I'm new to VBA and need some help to write a macro to draw scatter plots for each year and a pooled of all year with right x-axis scale (it's not correct on the current example plot) and a linear trend line. Eventually, I don't want plots contain data whether x-data or y-data is missing.
And can we limit the plotted data within 2 standard deviation only?
I've done programming on other languages like Matlab, Stata. Any example code will help as I think I can tweak it to work. But I need a start.
Attached is the example data.
Your help is very appreciate
Bookmarks