Hey everyone!

I'm having a small problem and I was wondering if anyone else knows a faster method of doing what I'm doing right now:

Currently, I have a large time series of data regarding weekly market shares of different companies. I have a graph that plots every individual company's market share of every week. This data is updated every week and therefore I made dynamic ranges using offset inside name manager so I do not need to expand the selection of the plot area every week.

However, I need to make a dynamic range for every single line (company) seperately. Now I am planning to add more companies to multiple graphs, but making a dynamic range for each and every company is going to be very tedious work. I tried to instead make a dynamic range that consists of more than one row and put it in the "Chart data range" line in the Graph options, but this fixes the range of the graph.

Does anyone here know how to do this without making a seperate dynamic range for each company seperately?