Legend - repeat of colours?

[User (Legacy)]

For some reason, the colours in the legend of my graph repeat. I can't seem

to find a reason in the code for this:

     ' These labels will appear in the tooltip

      for YCounter = 1 to benefit.rows

         benefit.row = YCounter

          If benefit.Value("BN-BEN-USED") = "0.00" then

          else

            Chart.Legend(YCounter-1) =  benefit.Value("BN-DESC")

          End If

       next

[Software FX]

But you are not setting your labels consecutively, how many points do you

actually have in this chart. I see only 3 Pie slices but I see many more

labels, most of them empty.

Maybe you want to keep another index counter in your loop so that only when

the data point is used you increment it.

-- 

FP

Software FX, Inc.