I have created lots of integrations with excel to create reports but now i have to create some graphs to go along with them and i am not too sure where to start, any pointers?

You might try the tools and utilities page of my web site. There is a white paper and code samples from the conferrence session that I did called "Creating Graphs With VFP"