Excel 2007 : Controlling chart placement from command button

Hi Everyone.
I recorded a macro of a chart I generated and I added a command button.The button works fine. The chart pops up but the placement is not where I want it. It pops up off the Excel page. I would like to control the exact area where the chart pops up. Is that possible? I tried recording a macro of me moving the chart to the correct location but when I tried to run that macro, it didn't include the replacement. It is possible to define an area where the chart must pop up? Any suggestions would be greatly appreciated.