Hi,

I am creating a stacked column chart and am having problems loading the 'series' names.

The underlying data is in a worksheet which has an overall range of A1:I366.

Cells A2 down to A366 have a year's worth of sequential dates, starting at Today().

Cells B1 to I1 have the 'Series Names' for the data set. Let's call them Peter, Paul, Mary,.... Jenna (8 in total)

I have created the column chart OK and all is well, except that the series names are showing as 'Series 1', 'Series2', ...... 'Series8'.

I can't seem to find a way of setting the series names to A2:I2. I can do them manually one by one, but Am I missing something ?

Mega-thanks as always for pointers & ideas. Trebor