Thanks Steven,

First of all, thanks for the SQL idea - I may pursue it if I'm wrong
about the following:

I think in this case at least, you're right, I don't need to rearrange
the data at all. What I was trying to do was have Age and Weight, for
example, as separate series with Name on the category axis. By
arranging the table as in table2, I could just drag the Info field to
the series slot, the values into the Data Items area, and that worked
fine. When I tried the same using Table 1, and dragging Age, say, to
the series box, Excel was trying to plot each individual value as a
series. However, with your prompting I tried a few things and found
that if I dragged Age and Weight into the Data Items field, that works
just the same. Which I now realise is the more obvious way of using a
pivottable. Hopefully the same will hold for my more complex example. I
seem to have a knack for making the simple more complicated than it is!

Cheers

Graham