Making a chart dynamic with variable rows as the series

[Peter Davison]

I have a chart that has a number of series for each row (e.g. AO6 to BA6 and so on)
As the number of rows (series) can vary from say 3 to 33 etc, Is it possible to make the series dynamic with an offset and count named range?
I've looked at google and the dynamic all seem to be by column as opposed to row.
Below is my data and chart I am using for help.
Appreciate any help.

 

[BSALV]

1. a lazy workaround, say you know the maximum of series 'll be 40 for example.
You create your chart immediately with 40 series (=columns) and you hide the extra ones, that are not necessary.

2. make it dynamic with VBA (manually, a lot of work) ???

 

[Peter Davison]

Okay thank you.
I did sort of do that but just with 25 out of a possible total of 100. 90% will always be within 25.
Thanks for your guidance.
It is well appreciated.