I have a spreadsheet which shows, in rows, the type of business brought in
by different salesmen. It also has a column which has each salesman's
initials in it. So the seller in each row can be identified.

The relevant part of the spreadsheet looks like this

Initials Date Product
Initials Date Product
Initials Date Product
Initials Date Product

I want to produce a chart of the business types sold by each salesman.
Obviously I can do it for the whole firm but how do I produce a chart for
each salesman?

Thanks

Rob Graham

You need to prep the data. You could simply filter the data on initials, and
only show one salesman's rows at a time. You could make a pivot table and
use initials as a page field, and display one salesman at a time by changing
the page field item.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"robgraham" wrote in message
...
I have a spreadsheet which shows, in rows, the type of business brought in
by different salesmen. It also has a column which has each salesman's
initials in it. So the seller in each row can be identified.

The relevant part of the spreadsheet looks like this

Initials Date Product
Initials Date Product
Initials Date Product
Initials Date Product

I want to produce a chart of the business types sold by each salesman.
Obviously I can do it for the whole firm but how do I produce a chart for
each salesman?

Thanks

Rob Graham

Ah! Pivot Tables. Right.

Thanks

Rob