Dynamic chart to allow for addition of new columns

[scaffdog845]

Hello everyone. I'm sure this is a simple solution but it's eluding me. I have a data area that is 11 rows tall and will never change. Each week a new column is added to the end of the data. I'd like the associated chart to automatically see and include that new column. Example - Current data is located in A5:N15 and the chart data range is set to =Summary!$A$5:$N$15. At the beginning of the next week there will be a new column of data added making the new range =Summary!$A$5:$O$15 As of now I need to make that change manually. How can I make it automatically update?

Thanks

[MrShorty]

Assuming I understand, the typical first answer is to use dynamic named ranges to build the chart. See one tutorial here: https://chandoo.org/wp/dynamic-chart-data-series/

[scaffdog845]

Thanks MrShorty. It seems like all the examples on Chandoo's page refers to making the chart grow based on the addition of new rows of data, not new columns of data and the link to download the example workbook does not work.

[MrShorty]

True that most examples are for adding rows (data series are in columns), but the concept is the same. Did you understand how the OFFSET() function worked for this? Did you understand how he uses the OFFSET() function as part of a named range? Adapting to a scenario like yours where you are adding columns (data series are in rows) is a simple matter of moving the counting function (COUNTA(...) in chandoo's examples) from the height argument of the offset function to the width argument of the offset function. OFFSET(A1,0,0,1,COUNTA(...))