Be sure to work off of the same file. Otherwise, I don't see why it would not work properly. Be sure to check that you have more than one chart on the activesheet.
MsgBox ActiveSheet.ChartObjects.Count