G
greg7468
Hello all,
I am trying to create a timeline that shows cycle times of a machin
in graphical form.
At present I have the table set out as below, I then create a pivo
chart showing the seperate processes stacked giving a total time.
When the process number is the same (say load) I would like all part
of the stack that are procees 1 to be the same colour, at the momen
all the different processes show a different colour.
I know you can change them individually but I may have hundreds o
charts to do and would only be feasible if the colours were automati
according to say the process number.
step process time
1 1 (load) 2
2 2 (press) 5
3 3 (transfer) 10
4 1 (load) 3
5 2 (press) 20
If there is an easier way of graphically showing cycle times broke
down into processes I would be very grateful of any advice.
Great thanks in advance
I am trying to create a timeline that shows cycle times of a machin
in graphical form.
At present I have the table set out as below, I then create a pivo
chart showing the seperate processes stacked giving a total time.
When the process number is the same (say load) I would like all part
of the stack that are procees 1 to be the same colour, at the momen
all the different processes show a different colour.
I know you can change them individually but I may have hundreds o
charts to do and would only be feasible if the colours were automati
according to say the process number.
step process time
1 1 (load) 2
2 2 (press) 5
3 3 (transfer) 10
4 1 (load) 3
5 2 (press) 20
If there is an easier way of graphically showing cycle times broke
down into processes I would be very grateful of any advice.
Great thanks in advance