Hi, I'm hoping someone can help me out with this dilema I have:

I'm working on a project that involves analysing data - being errors created
within a process - such as wrong colour, wrong size, damaged etc. In the past
I've used the pivots as 'source data' to create graphs, but it's very fiddley
in terms of having to change the values on each of the pivots to give a clear
picture of the graph for each day or week. What I would like to do is create
a graph directly from a table that is updated by the pivots. This enabling a
simply highlight of the column for each heading and changing the highest to
the lowest, rather than going to each of the pivots and modifiying each one.

To start each error is created by an operator of which they may create errors
over a period of time dates that form weeks. So as example for this week over
7 days we call week 1. Next week will be week 2. But for week 1 I want to be
able to produce a graph that shows all the errors created in that week by the
different operators and so on each week. How do I create this table and it be
fixed that the operators are updated accuately with each of the errors they
create for that week, that is directly updated by the pivots?

Thanks
JP

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200803/1