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!

On Mar 27, 3:14 pm, "Greggy" <greg.kel...@gmail.com> wrote:
> 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?