I can find a lot of information on creating dynamic ranges (mainly for charting purposes), when the dynamic portion is the column.
I have a column (A) of metrics, and each column after is a month for the corresponding metric
Metrics | April | May | ...
-----------------------------------
Metric #1 | 5 | 4 |
Metric #2 | 2 | 3 |
I want to be able to populate the months data as time progresses and have the range accept them, which the chart is pointing to for the series.
I don't know how to create a series that is dynamic going horizonatally. I googled and only see examples for the inverse.
Any help would be greatly appreciated
Bookmarks