Chart Help - multiple axis

[Sam]

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

 

[Bruce Sinclair]

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

 

[Jon]

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