Can you please walk through the below mentioned link:
VBA Code to Create & Format Charts in Excel - YouTube