Construct a pivot table with the data, put Date into the row area, and sum
of Licenses in the data area.
Incidentally, for most uses, it's better to store the date-time in a single
column. Excel treats dates as a whole number (the number of days since
1/1/1900) and times as the fraction of the day since midnight (6:00 am =
0.25).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"plsntn_rules" wrote in message
...
Ok..I have a spreadsheet that has 3 different sets of data..
Column 1 is the date.
Column 2 is the time.
Coulumn 3 is the number of licenses used.
So for example...
12/15/2005 4:15 PM 42
12/15/2005 5:15 PM 39
12/15/2005 6:15 PM 34
.
.
.
The goal here is to show in a graphical format how many licenses are being
used throughout the day in a typical week...
How do I chart this?
Thanks for any help...