I want my chart to update automatically as I add additional data to a column. I understand that we can revise the Series to use a formula. I believe it needs to use Offset in combination with Count, but can't work out the precise formula. Does anyone remember this formula? Thanks, Andy.