Rows of data, using status columns to sort data to pie chart on another worksheet tab

[Greggy]

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!

 

[Greggy]

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!

Maybe it's not possible. Can someone point me somewhere?