Hi,

This is what the data would look like:

Range Month Assigned Un-Assigned
0-29 Jan 2000 1200
30-59 Jan 1150 523
60-89 Jan 85 32
90+ Jan 1 0

0-29 Feb 2200 1100
30-59 Feb 850 725
60-89 Feb 101 52
90+ Feb 3 2

The boss wants to see in one graph by month how the assigned and un-assigned
change for each range. This would be update monthly and we may even enter
all of last years data so we can see a pattern.

Thanks

Michael



"ShaneDevenshire" wrote:

Hi,

Diagram a small sample of the data for us.

Date Age Number
1/07 0-29 34
2/07 0-29 12
1/07 30-69 5
....


--
Thanks,
Shane Devenshire


"THE BIG O" wrote:

Hello,

I am helping someone with a chart and I am a bit stumped. The chart needs
to show for each month the number of items that are assigned or unassigned.
Not only that but each assigned and unassigned quantity of items is of a
certain number of days which is to be shown in the chart as well. (0-29,
30-59, 60-89, and 90+).

The boss wants a line graph but I am not sure this works. I have not
created very many charts and most of those have been simple bar or pie
charts. This is a little over my head.

Would a line graph be possible and if not, what is the best way of doing this?

thanks

Michael