Thread: How to chart 3 sets of data?

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
http://PeltierTech.com/
_______


"plsntn_rules" <plsntnrules@discussions.microsoft.com> wrote in message
news:BEAF076A-E36F-4021-904A-DF6C89B9B8DA@microsoft.com...
> 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...