Making an excel chart dynamic

[Peter Davison]

HI all,

I'm trying to make an excel chart dynamic to cater for the varied number of rows in it each time the data is imported.

I have created a named range for each series and I am using the following offset formula -

=OFFSET('Rep Writer Variance Report'!$B$1,0,0,COUNTA('Rep Writer Variance Report'!$B:$B),1)
For each of the 6 series ranges I have changed the column each time so the above in column B accounts for the first range and column G will be for the last 6th range, I also used the last digit number as 1 because each range is 1 column.

In each of the series ranges I am using the workbook name and the named range (e.g. below)
='Filename.xlsm'!VarianceGraph_MinimumPercentage


When I have done the above my chart is not charting to only the rows with data - 17 rows (see picture uploaded)

What am I doing wrong?

Any help would be appreciated

 

[Peter Davison]

Hi,
I've just watched a video on the above and have now cracked it.
Cheers