I have to chart the following


I have multiple users with 4-5 different status and multiple dates,
some sample data is below

03/02 - name 1 - open - 5 items
03/15 - name 1 - open - 10 items
03/02 - name 2 - open - 0 items
03/15 - name 2 - open - 10 items
03/15 - name 2 - closed - 5 items
03/02 - name 3 - open - 5 items
03/02 - name 3 - pending - 8 items
03/15 - name 3 - open - 14 items

I need to show a trend by user by status & by date

I'm not sure how the table needs to be set up or if the chart can be
done for this. Could someone please provide assistance?

Thanks

In article <76f9abb1-e7eb-4b24-86b7-(E-Mail Removed)>, Sam <(E-Mail Removed)> wrote:
>I have to chart the following
>
>
>I have multiple users with 4-5 different status and multiple dates,
>some sample data is below
>
>03/02 - name 1 - open - 5 items
>03/15 - name 1 - open - 10 items
>03/02 - name 2 - open - 0 items
>03/15 - name 2 - open - 10 items
>03/15 - name 2 - closed - 5 items
>03/02 - name 3 - open - 5 items
>03/02 - name 3 - pending - 8 items
>03/15 - name 3 - open - 14 items
>
>I need to show a trend by user by status & by date
>
>I'm not sure how the table needs to be set up or if the chart can be
>done for this. Could someone please provide assistance?

I've seen a multi chart templetand examples using XL. IIRC, it was called a
'panel chart' ... basically, you could put similar charts next to each other
(vertically or horizontally) for comparisons. Perhaps that is the way to go
here ?

HTH

Make a pivot table from the data, and see whether you can get an arrangement that shows the data in a sensible way.

There is a tutorial about pivot tables on my web site:
http://peltiertech.com/Excel/Pivots/pivotstart.htm