View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sean McCloskey
 
Posts: n/a
Default Charting number of contacts a day

So here's what I am trying to do, I have a source table with the following
entries:

00006 - Main Support Closed m 1/12/06 11:44 AM
00006 - Main Support Closed m 1/12/06 11:27 AM
00006 - Main Support Closed m 1/10/06 10:41 AM


Two columns. What I want to do is create a chart where it shows for example
Jan 12, there were 2 entries, and Jan 10, there were 1 entry. Ofcourse this
has to be scalable to a larger set. I just want to see the trend of entries
per day.

I don't want a bunch of =Countif's if possible. Ideas?