Hi there,

1.  I have 50 rows of data.  There are many columns, but, there is one
status column that I use to group the rows of data into
relationships.   I would like to build individual charts based on the
status column.  So, if I say these items are part of "Group A",
information from those rows that are "Group A" will automatically show
up on a chart on the "Group A" worksheet tab pie chart.  I will have
"Group A", "Group B", "Group C" pie charts on seperate worksheet
tabs.  Now, I want to move an item from "Group A" to "Group C". So, in
the status column I change "Group A" to Group C".  So now it
automatically moves off the "Group A" pie chart to the "Group C" pie
chart.

2.  Also, beside the "Group C" chart, I would to list a summary of the
data (in text format) of all the rows that are part of the "Group C"
status.  If I move the data to a "Group B" status, excel moves the
data to the "Group B" pie chart and summary list.

Phew! Was this too much for one post?? :)

Thanks!