As far as I know, you can use Microsoft Graph 14.0 Object Library to create graphs via VBA. However, there are few articles about how to use this. Please take a look at this aritle:
http://www.vb123.com.au/toolbox/99_graphs/msgraph1.htm
I hope this can help you and feel free to follow up after you have tried.