Brilliant.That makes complete sense. I will employ your method.

I did think, too, that the second chart type you describe would be
simpler to implement, but this is part of a design project for a
client and they specifically requested the former type of chart.

Thank you very much for your help.

annie