Programatically creating charts in excel is BEYOND the scope of this forum. we cannot provide you with a trunkey solution such as these. If you post some code, we can help, be we cannot perform this task for you. Once again, we can help if yuo are stuck and getting errors, but we are not going to deploy a solution.
It is more times than not, that we spend time writing up a solutiion, and it NEVER comes out to be what the person wanted, because they failed to mention it only needed to happen on a blue moon, (or some other obscure details they fail to mention). We then have to scrap our work, and start over.
Post you code, and we can help.
It's kind of fun to do the impossible! -Walter Elias Disney