software

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

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
PeltierTech.com/
_______quot;plsntn_rulesquot; gt; wrote in message
...
gt; Ok..I have a spreadsheet that has 3 different sets of data..
gt; Column 1 is the date.
gt; Column 2 is the time.
gt; Coulumn 3 is the number of licenses used.
gt;
gt; So for example...
gt;
gt; 12/15/2005 4:15 PM 42
gt; 12/15/2005 5:15 PM 39
gt; 12/15/2005 6:15 PM 34
gt; .
gt; .
gt; .
gt;
gt; The goal here is to show in a graphical format how many licenses are being
gt; used throughout the day in a typical week...
gt;
gt; How do I chart this?
gt;
gt; Thanks for any help...