Hi Richard

I have a worked out example on my Excel / soccer website. But mind you, the
site is in Dutch... Thus I will guide you.

Visit http://www.wimgielis.be, choose Excel in the left navigation bar, then
Voorbeeldbestanden (left bar), then on that page, search for Evolutiegrafiek.
Download an Excel file by clicking the picture.

The chart is on the second tab. I uses a forms listbox. Give it a whirl and
try to understand where the data come from. I used a few named ranges on the
first tab.

Good luck with it.

Wigi