Trouble Displaying a Non-Contiguous Data Range

I'm having trouble creating a chart that shows days off that individual
employees are taking for a particular month. I can create an underlying
data table, but I'm unable to create a chart based on the data. I'd like
the chart to look something like this with days of the particular month on
the Y axis and the names of the people on the X axis:

Month of July
31
30
29
28
..
..
5
..
..
1
Sue Mary ..... Tom

I'm having trouble displaying a non-contiguous data range for a particular
person (x value). If Sue were to take off, for example, from the 5th to the
10th of the month and then from the 15th to the 22nd of the month, how
would I display that? Is it possible? I want to have a side by side
comparison for all the people showing time off.

Thanks,

Dave

You could use a worksheet to display the days off, as Jon Peltier
describes in his Gantt chart article:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

David wrote:
I'm having trouble creating a chart that shows days off that individual
employees are taking for a particular month. I can create an underlying
data table, but I'm unable to create a chart based on the data. I'd like
the chart to look something like this with days of the particular month on
the Y axis and the names of the people on the X axis:

Month of July
31
30
29
28
.
.
5
.
.
1
Sue Mary ..... Tom

I'm having trouble displaying a non-contiguous data range for a particular
person (x value). If Sue were to take off, for example, from the 5th to the
10th of the month and then from the 15th to the 22nd of the month, how
would I display that? Is it possible? I want to have a side by side
comparison for all the people showing time off.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

That was helpful!.

Thanks...


"Debra Dalgleish" wrote in message
...
You could use a worksheet to display the days off, as Jon Peltier
describes in his Gantt chart article:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

David wrote:
I'm having trouble creating a chart that shows days off that individual
employees are taking for a particular month. I can create an underlying
data table, but I'm unable to create a chart based on the data. I'd
like
the chart to look something like this with days of the particular month
on
the Y axis and the names of the people on the X axis:

Month of July
31
30
29
28
.
.
5
.
.
1
Sue Mary ..... Tom

I'm having trouble displaying a non-contiguous data range for a
particular
person (x value). If Sue were to take off, for example, from the 5th to
the
10th of the month and then from the 15th to the 22nd of the month, how
would I display that? Is it possible? I want to have a side by side
comparison for all the people showing time off.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html