Hi, Chart guru's,

I have created a spreadsheet with multiple columns that use formulas for
getting the chartdata.
Depending on a datavalidationlist different charts can be made within only
one chartobject.
Sometimes this results in a chart with less series than the maximum.
For this purpose I have put an If condition in my formula that causes the
formula result to become #N/A()
That works fine for the series, but in my legend the color for that series
remains, giving #N/A as the description.

Does anyone of you know a sollution for this?

Thanks in advance,

Ernst Schuurman