How to chart 3 sets of data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/
_______
 
Back
Top