Chart Help - multiple axis

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
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?
Click to expand...

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
 
Back
Top