Terry wrote:
I have spreadsheets with a lot of data in them. I have multiple columns.
The two columns I need to compare right now have initials in one column and
dates in another column. The initials are nurses and the date column is a
denial date. I need to create a chart that will show a possible trend of
certain nursing staff having a higher number of denials. I know I highlight
those two columns, but I think I have to change the date data to something
that can be counted???

Please advise. I am desperate. and there are more of these kind of charts
to come that I will have to do.

Thank you in advance for any assistance.

You don't need to change the date data. After you highlight the two
columns, fire up the pivot table wizard, place the nurse initials in the
Row area and the denial dates in the data area. The dates should default
to "count of date".

With that said, (and I'm sure you thought of this) to get a rate of
denials it seems you need some kind of total per nurse as a basis of
comparison.