Legend entries dissapear
 

Hi:
I have a workbook (Excel97) that has a spider chart with 14 dots. I
have code that sets the color of each dot according to the score the
dot represents. The dot values are set by a single series of cells. I
go through the legend items to change the dot color.

Everything worked fine for quite sometime, but now whenever one the
users makes changes to the scores (on separate worksheets in the same
workbook) then goes back to the spider chart, all the legend entries
have dissapeared save 1. Now, all dots have the color of the one
legend key, and the code can not find the other legend items.

Anyone with clues as to why the legend entries are falling off would
be greatly appreciated. I should note that I can not replicate this
problem on my computer.