View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How to chart 3 sets of data?

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