If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Different charts for different salesmen
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 |
#2
|
|||
|
|||
Different charts for different salesmen
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 |
#3
|
|||
|
|||
Different charts for different salesmen
Ah! Pivot Tables. Right.
Thanks Rob |
Thread Tools | |
Display Modes | |
|
|