Can you create self updating charts in macro enabled worksheets?

Just a quick one,

I've been trying to create a graph that self updates when you add new data to the range, however it does not seem to be working on my current macro enabled worksheet.

I've tried using the same technique on another sheet and it works fine.

The formula that I'm using are:

Define the names

=OFFSET(Sort!$C$7,0,0,COUNTA(Sort!$C$6:$C$600)-1)

=OFFSET(Sort!$B$7,0,0,COUNTA(Sort!$B$6:$B$600)-1)

Chart Formula

=SERIES(Sort!$C$7,ChangeoverTimesUpdate.xlsm!Obs_No,ChangeoverTimesUpdate.xlsm!CO_1,1)

I try to press enter and literally nothing happens.

Cheers,