software

I have the following dataset. For each person in Column A, I want to
find their maximum sales $ in Column B for each of the location in
Column C and plot them out in a bar chart. There will be always two
locations (series) for each person.

A B C D
1Faye 14,874 China7/4/2005
2Faye 18,050 China6/27/2005
3Faye 31,255 US6/20/2005
4Faye 56,351 US6/13/2005
5Faye 59,352 US6/6/2005
6Faye 74,887 US5/30/2005
7Jean 42,671 China5/23/2005
8Jean 45,560 China5/16/2005
9Jean 60,170 China5/9/2005
10Jean 100,357 US5/2/2005
11Jean 112,163 US4/25/2005
12Jeff 18,078 China4/18/2005
13Jeff 26,859 China4/11/2005
14Jeff 49,090 US4/4/2005
15Jeff 74,579 US3/28/2005
....
....

Thanks for any input. I appreciate it.

Faye LarsonYou can use the PivotTable and PivotChart report, and layout the report with
the columns A and C in the rows, and the Max of column B in the data. That
will make all the calculations for you.

Hope this helps,
Miguel.

quot;Fayequot; wrote:

gt; I have the following dataset. For each person in Column A, I want to
gt; find their maximum sales $ in Column B for each of the location in
gt; Column C and plot them out in a bar chart. There will be always two
gt; locations (series) for each person.
gt;
gt; A B C D
gt; 1Faye 14,874 China7/4/2005
gt; 2Faye 18,050 China6/27/2005
gt; 3Faye 31,255 US6/20/2005
gt; 4Faye 56,351 US6/13/2005
gt; 5Faye 59,352 US6/6/2005
gt; 6Faye 74,887 US5/30/2005
gt; 7Jean 42,671 China5/23/2005
gt; 8Jean 45,560 China5/16/2005
gt; 9Jean 60,170 China5/9/2005
gt; 10Jean 100,357 US5/2/2005
gt; 11Jean 112,163 US4/25/2005
gt; 12Jeff 18,078 China4/18/2005
gt; 13Jeff 26,859 China4/11/2005
gt; 14Jeff 49,090 US4/4/2005
gt; 15Jeff 74,579 US3/28/2005
gt; ....
gt; ....
gt;
gt; Thanks for any input. I appreciate it.
gt;
gt; Faye Larson
gt;
gt;

How can I include the column D in the pivat table?

FayeChina180506/27/2005
US748875/30/2005
JeanChina601705/9/2005
US1121634/25/2005
JeffChina26859...
US74579...
....
....

Thanks, again.

Faye LarsonGood question, the pivot table won't allow to put the date directly on the
data section, and droping in any other area will distort the table.
I don't know how to do that in an easy way, sorry. Also, because it comes
from a pivot table, you cannot play too much with the source data options, so
if having the date is a must then the pivot chart may not be the correct
solution for your case.

Miguel.

quot;Fayequot; wrote:

gt; How can I include the column D in the pivat table?
gt;
gt; FayeChina180506/27/2005
gt; US748875/30/2005
gt; JeanChina601705/9/2005
gt; US1121634/25/2005
gt; JeffChina26859...
gt; US74579...
gt; ....
gt; ....
gt;
gt; Thanks, again.
gt;
gt; Faye Larson
gt;
gt;