VBA Actual date datas to make a graph

[tomahawk61]

Hi,

I am a very new to excel macro and I need help.


we have 3 shifts at the factory.

06:00-14:00 morning shift

14:00-22:00 late shift

22:00-06:00 night shift

I would like to see the 3 shifts breakage and rework graph in an another excel workbook. But I want to see the actual date datas. In every shift I would like to see the past 2 shifts and the actual shift. Is it possible?
(3 Graphs>> actual shift and the past 2 shifts)

I would like to do it like a simple dashboard

Thank you for your helps!

 

[Rijnsent]

Hi Tomahawk,
I understand the input data, but what would the output be? A list of some kind? A chart? I assume the data should update automatically with the last shift as the base and the two before shown as well? Thanks for some clarification.

 

[tomahawk61]

Hi Tomahawk,
I understand the input data, but what would the output be? A list of some kind? A chart? I assume the data should update automatically with the last shift as the base and the two before shown as well? Thanks for some clarification.

Hi A chart that shows the shift breakage information(actual shift and the last 2 shifts). I can send you what I have done until now.