Hi guys,
I'm using a named range using offset and counta formulae to create a dynamic chart. It works basically how I want it to however all my ranges miss the very last entry and I can't see what I've missed. This is one of my named ranges:
=OFFSET('Branch 1'!$Q$17,0,0,COUNTA('Branch 1'!$Q$17:$Q$137))
I'm then using the named ranges for the x and y series data in the chart to update automatically as new data is entered. Which it does, except for the final entry. It's always one short. Any idea what I've missed? Thanks.
Bookmarks