I am trying to create a smartart (pyramid style) for 3 ranges of testing data. In each level of the pyramid, I'd like to have the students' name and score inserted in the section that meets the range.

I've read that Excel '10, can insert forumulas into the boxes, but is there a way for 07?

example:

top portion - <400
middle portion - 400-499
bottom portion - >499

thanks!