I would like to know how to get VBA to find the range for a chart by looking for the last row and column of an array. Basically find the last row in multiple data series.

Currently, I am setting the range manually but would like to automate it.

I was not sure how to word the question on google so I was not able to find similar posts.