Thanks, Andy - I'll have a play with that and see if I can get it to work.
It's not actually a contrived example; I work for a paint company so the real usage is exactly the same, just with more colours and "Chart Value" replaced with our profit figures.
Bookmarks