data source for chart

  • Thread starter Thread starter Terry
  • Start date Start date
T

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.
 
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
 
Back
Top