data source for chart

[Terry]

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.

 

[smartin]

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.

 

[Jon Peltier]

You can refine the pivot table approach further.

Drag the initials to the columns area, and the date to the rows area. Then
drag the date to the data area, so the field appears twice in the table.
Right click on the Date field button in the rows area, and group the dates,
either by month, or by week (i.e., seven days), or whatever makes sense.
This gives you rate vs. time.

- Jon