How do I count the # of times a value reoccurs and plot it over ti

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to plot a number of errors made by each users and compare it over
time. I have a column of user ID's and a column of dates. I want the chart
to count the number of times each user ID appears and plot against it's
corresponding date. However, each time I try to do this, the chart appears
wrong. Any ideas?
 
I wish to plot a number of errors made by each users and compare it over
time. I have a column of user ID's and a column of dates. I want the chart
to count the number of times each user ID appears and plot against it's
corresponding date. However, each time I try to do this, the chart appears
wrong. Any ideas?
Click to expand...
I don't quite understand what you want to do. If you count the number
of times a userid appears, how would you then relate this count against
one specific date.

In general, the simplest way to handle these kind of analysis (whether
count by userid or count by userid by date) is with a PivotTable and an
associated pivotchart. See Data | Pivottable and Pivotchart report...
Once you have the Pivottable, put the userid as a row field (depending
on what you really want the date field may also be a row field). Put
the userid (or date) as the data field. If the default XL picks is not
'count of {field}' change it to count.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I'm sorry, I must have phrased it wrong. What I meant to say was that I
wanted the ID plotted against it's corresponding date each time it shows up.
I've tried a pivot table, but the data is incorrect. For example, one of the
ID's has only 2 errors on 2 different dates, but the chart shows it as if it
has 1 error on every date but 3. Those 3 dates are the dates that the user
actually had an error and it shows 2 errors on those dates, and the other is
one date where the user has no errors and it shows 0 (which it should). I
want the chart to reflect the actual number of errors per date.
 
Back
Top