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,

You're close but not quite there...
1. Set up your dynamic named range.
> Go to the ribbon -> Formulas and select the "Name Manager"
> Select the "New" button
> Give your range a name (No spaces or special characters)
> In the "Refers To" box enter your offset formula ... (=OFFSET(Sort!$B$7,0,0,COUNTA(Sort!$B$6:$B$600)-1))
> Click Ok
> In the main Name manager form select the "Refers To" box and verify the data of interest is correctly highlighted.
2. Assign Named range to the chart
> Select your chart
> Choose "Select Data"
> Select the series
> Select "Edit"
> In the values box type the named range in the format : =Book1.xlsm!ExampleData......... i.e workbook name and range name.

Change the counta in the offset formula to count.
Change the chart properties ...
> Right click on chart
> Choose "Select Data"
> Select the hidden and empty cells button to set how the chart deals with data gaps