formatting pivot chart bar colour

[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

 

[Jon Peltier]

Greg -

I posted a macro in this thread which you can adapt to your project:

http://groups.google.com/groups?selm=#[email protected]

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______