Could you mock up a pie chart in the way you want in Excel please, long with the values that make it up?
That would help a lot.
Thanks for forcing me to re-evaluate my data organization. I had to create a new spreadsheet to make it work (created a new attribute column), but I was able to join the new sheet to the original sheet to create the correct pie chart.
John, I'm a bit of a neophyte when it comes to the joins and I want to perform a similar transformation. Could you post the code for the query where you performed the join?