Microsoft Access 2000 Chart with Multiple series

[gdjustiniano]

Hi - MS Access 2000 Chart wizard only allows for 1 series when creating a bar graph- I need 2. Can this be done? Basically I need a stacked bar graph. Right now the row source field reads something like this:
"TRANSFORM SUM(x) SELECT Z FROM Table GROUP BY Z PIVOT W". This isn't sufficient since I need to breakdown W even further. Aprreciate any advice you can give me. Thanks.