I have a large complex sales tracking template with named ranges for
most everything.
One sheet has each "deal" record data with a salesperson field.
On another sheet I have calculated value for each deal.

I wish to total sum just the deal values that have been "Won" for each
salesperson and dynamically pie chart each salespersons total $$.
This chart will change as more deal records are added.

A little guidance please...

Dennis

On Feb 18, 10:03*pm, ssGuru <weca...@gmail.com> wrote:
> I have a large complex sales tracking template with named ranges for
> most everything.
> One sheet has each "deal" record data with a salesperson *field.
> On another sheet I have calculated value for each deal.
>
> I wish to total sum just the deal values that have been "Won" for each
> salesperson and dynamically pie chart each salespersons total $$.
> This chart will change as more deal records are added AND Won that is.
>
> A little guidance please...
>
First need to gather just the Won data together by Salesperson and
then point the chart at the combined data.
> Dennis