Hi Dave ,
I am already using
Private Sub Workbook_Open()
but this is not helping the moment I try to plot the char it is giving the error :
Method "Location" of object "_Chart" failed
at statement :
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
Sheet1 is the active sheet.