Need help creating graphs

[DKRbella0814]

Inside a spreadsheet, I have created a form that tracks production data (# good parts run per a defined period of time) for up to three different jobs run on a single machine within a machining cell.

For example, once cell called the VCM cell, consists of 6 different machines:

M24, M15, M34, M14, M06, M31


During 1st shift, up to three different jobs can be run on any one of the above machines in the VCM cell.

For 4 defined time periods, I collect data on how many good parts were run

This data is summarized in the following format on the side of the form for each machine:
col (AI) (AJ) (AK) (AL)
Actual % Expected % #Actual #Expected

M24(Job1) Time1 50% 65% 10 13
Time2 40% 50% 5 7
Time3 60% 70% 12 15
Time4 80% 90% 13 14

M24(Job2) Time1 50% 65% 10 13
Time2 40% 50% 5 7
Time3 60% 70% 12 15
Time4 80% 90% 13 14

M24(Job3) Time1 50% 65% 10 13
Time2 40% 50% 5 7
Time3 60% 70% 12 15
Time4 80% 90% 13 14



How can I create a graph so that all of the data for a single machine (M24) displays the actual vs expected production data for up to 3 jobs during four different time increments?

 

[Rasm]

Check these out

http://peltiertech.com/Excel/Charts/ChartIndex.html

http://www.andypope.info/charts.htm