Basic chart question

[fitful_thought]

Column A contains dates
Column B contains the salesman's name
Column C contains the gross sales for the day

I'm trying to determine if it's true that when a certain salesman is on duty
the gross sales increase and when he's absent they decrease.

So column B either contains his name or is empty (if he was not working that
day).

I have no experience with charts, so any help at all will be most
appreciated.

rgds,
DL

 

[Barb Reinhardt]

If it were me, I'd probably look at the data with a Pivot Table and review
the average gross sales by salesman. Here is a link to info on Pivot
Tables.

http://www.cpearson.com/excel/pivots.htm

If someone else can assist with other info, have at it.