Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number format | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |