I've been reviewing the helpful links given in this forum for dynamic charts,
and I've learned a great deal. All of the links I've reviewed focus on the
ability to have the range of data points displayed for a GIVEN # of series be
dynamic, but in all those cases the number of series was static. They focus
on editing the SERIES formula with COUNTA and OFFSET functions, so they can
move. In the problem I'm working on I need to have the actual number of
series be dynamic.

In my example...

0 1 2
a 5.57% 4.35% 3.66%
b 5.58% 3.44% 2.05%
0 0.00% 0.00% 0.00%
0 0.00% 0.00% 0.00%


I'm using a line chart. I have condition 0,1, and 2 and I have series a&b.
The zero cases(what would be series c&d) are automatically filled in if
another condition is met. But the chart has to be modified each time. If I
understand the dynamic charting correctly, I could add a condition 3, 4 and 5
and have them automatically reflected in the chart, but I'd like the chart to
recognize when additional series c&d are added. Is this possible?

Hoping chart MVP's are around. Thanks,
Dave