How can I group time on the X axis. For example,

13:00 - 13:30, 13:30 - 14:00, 14:00 - 14:30

What's the data like? Are you counting instances within a time frame,
summing them, or what?

Is a histogram what you need?

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GEM" wrote in message
...
How can I group time on the X axis. For example,

13:00 - 13:30, 13:30 - 14:00, 14:00 - 14:30

Thanks Jon...

What I need to put on a graph is the time of day when the most work is done
by different users. For example,

User 1
13:00 - 13:30: sold 13 items.
13:30 - 14:00: sold 2 items.
14:00 - 14:30: sold 1 items.

User 2
13:00 - 13:30: sold 14 items.
13:30 - 14:00: sold 1 items.
14:00 - 14:30: sold 2 items.

Here you can see the most work is done from 13:00 - 13:30.

This is a small example, but I need to graph it for about 60 different users
under the same time intervals.

Would you know how???
Thanks!!


"Jon Peltier" wrote:

What's the data like? Are you counting instances within a time frame,
summing them, or what?

Is a histogram what you need?

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GEM" wrote in message
...
How can I group time on the X axis. For example,

13:00 - 13:30, 13:30 - 14:00, 14:00 - 14:30

Is the data already compiled? Then set it up as in the table under the
"Dynamic Do-It-Yourself Histograms" heading in the page I cited:

http://peltiertech.com/Excel/Charts/Histograms.html

(about halfway down), but instead of the formulas, just enter your counts.
To make it easier, just enter the time ranges in column A (e.g., enter
13:00 - 13:30 in A2, 13:30 - 14:00 in A3, etc.). Then enter the first set of
counts in column B, the next in C, etc. Make a histogram (column chart) with
the data in A2 to Bwhatever. Copy the chart, go to Chart menu Source Data
Series tab, and change the range in the Values box from column B to column
C. Repeat for the rest of your columns.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GEM" wrote in message
...
Thanks Jon...

What I need to put on a graph is the time of day when the most work is
done
by different users. For example,

User 1
13:00 - 13:30: sold 13 items.
13:30 - 14:00: sold 2 items.
14:00 - 14:30: sold 1 items.

User 2
13:00 - 13:30: sold 14 items.
13:30 - 14:00: sold 1 items.
14:00 - 14:30: sold 2 items.

Here you can see the most work is done from 13:00 - 13:30.

This is a small example, but I need to graph it for about 60 different
users
under the same time intervals.

Would you know how???
Thanks!!


"Jon Peltier" wrote:

What's the data like? Are you counting instances within a time frame,
summing them, or what?

Is a histogram what you need?

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"GEM" wrote in message
...
How can I group time on the X axis. For example,

13:00 - 13:30, 13:30 - 14:00, 14:00 - 14:30