Shift Records - Is this even possible?

[Whistler]

Hi,

I Have a database with column like this: Date, Shift, Line, Yield, Review , Output, Deselections, ...

I have been asked to add to a Dashboard a Shift record table or chart which will be showing Shift record, or best output for each shift. There is 9 lines.

I spent couple of days thinking about this and I cant find solution, is this even possible?

Any help much apreciated.

Marcin

 

[Leith Ross]

FYI - This question has also posted at the Excel Forum here

 

[Whistler]

I this thread will continue on this link: http://www.excelforum.com/excel-programming/791620-shift-record-is-this-even-possible.html

Sorry if I if I upset anyone.

Regards

Marcin