In article ,
says...
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 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