Hi,
I am trying to create a dynamic chart sourcing all of the data from a named range. I've named the range using the OFFSET method and, having tested it, it dynamically updates when the data is altered. I have tried to use this as the source for my chart (i.e. chart data range = 'sheet1'!NamedRange) but every time the data changes the chart looses the named range and does not update. Is there something further I should be doing in order for the chart to update?
TIA,
Alan.
Bookmarks