Can I have a chart pickup range of data in a column where it starts with a predetermined cell and ends with a "dynamic" cell–last one in the column that holds a value?
Every time I supplement data to my column I have to change chart data source to reflect the newly added rows. I'd like the chart to pick the end of data automatically.

I found this VBA... not sure if I can plug it in this instance
Please Login or Register  to view this content.