Hi,

I'm trying to reproduce graphs with some vba code. However, I'm coming unstuck where the series' have automatic colours/styles set. While I understand that for each automated series Excel uses a different palette colour (starting with the Chart Fill colours along the bottom line of the palette), but I can't figure out where the index of the series is stored - i.e. which colour from the palette to use.

For example, if I have 3 series on a line chart then they're initially setup with automatic colouring and given the first 3 automatic colours...if I then delete series 2, the 3rd series still has the third colour...i.e. somehow Excel still knows that the series was created as the thrid series, even though there are now just two. And if you then add another series, it is given the 2nd colour in the automatic list. But searching through the series' properties, I cannot for the life of me see how Excel is recording what the index number for each series is.

Anyone any suggestions? Any help would be much appreciated.

Thanks,
Phil.