Hi. I have a chart with 96 series, these series have around 76 data points
each and are expressed in a line chart. I would like to be able to
automatically colour the lines for each series based upon the name of each
series. The names of each series are identified by the header of the
particular column/row.

Is this possible?

I have looked through other questions on here, but they dont seem to be
relevant to this particular case.

Thanks in advance.

James