In the last step of the Chart Wizard, specify the appropriate location.
As far as making it "look nice" goes that would depend on (a) the
purpose of and the relationship between the charts and (b) your
definition of nice.
--
Regards,
Tushar Mehta www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions