I have an office application that logs how many times aspects of the program
is used. It logs the Users Name in one column, then the area of the program
in the next column. I for the life of me can not get an reasonable output
looking chart from this data. What i would love to see is a broken down list
for say user Tish from the data below, and have the chart log how many times
they used each aspect of the program. (i.e. In Out Log, Drafting Log,
Engineering Log, and so on.) That way i can show that user what areas of the
program they are using.

Here is some sample data to help. I have roughly 40,000 rows of data so any
help would be much appreciated.

Thanks,

Mark

CAD In Out Log

BRANDON In Out Log

BRANDON In Out Log

JOSH In Out Log

CAD In Out Log

BRANDON In Out Log

ROGER Retrieve Job

Tish Drafting Log
Tish Drafting Log

MARK DOUGLAS Drafting Log

OWNER Drafting Log

OWNER In Out Log

JOHN In Out Log

Tish In Out Log

BRANDON Drafting Log

It sounds like you need to consolidate the data first, I would probably make
a list of one of each name (using Advanced Filter, Unique Values) and then
put the different activities as the column headings and create a table of
counts of each activity (you can do this using a sumproduct or array
formula). For the data you have shown, if it were in cells A1:B15 you could
set up the following table, say in cells E1:H9

Name In Out Log Retrieve Job Drafting Log
Mark
Cad
Brandon
Josh
Roger
Tish
Mark Douglas
Owner

You can use a formula like
=SUMPRODUCT(($A$2:$A$15=$E2)*($B$2:$B$15=F$1))
to get the total counts (assuming the first formula is in cell F2 beside
'Mark'). If you plot a stacked column graph from this data you will see each
user's total number of uses and it will be broken down by type.

Andrea Jones
www.allaboutclait.com


"Mark Douglas" wrote:

I have an office application that logs how many times aspects of the program
is used. It logs the Users Name in one column, then the area of the program
in the next column. I for the life of me can not get an reasonable output
looking chart from this data. What i would love to see is a broken down list
for say user Tish from the data below, and have the chart log how many times
they used each aspect of the program. (i.e. In Out Log, Drafting Log,
Engineering Log, and so on.) That way i can show that user what areas of the
program they are using.

Here is some sample data to help. I have roughly 40,000 rows of data so any
help would be much appreciated.

Thanks,

Mark

CAD In Out Log

BRANDON In Out Log

BRANDON In Out Log

JOSH In Out Log

CAD In Out Log

BRANDON In Out Log

ROGER Retrieve Job

Tish Drafting Log
Tish Drafting Log

MARK DOUGLAS Drafting Log

OWNER Drafting Log

OWNER In Out Log

JOHN In Out Log

Tish In Out Log

BRANDON Drafting Log