URGENT Help Requested: Need help in excel graphs
Hi Experts,
Following is my data, i need to present week wise project status for entire program hence project ids are not required. Earlier i was expected to give consolidated report (irrespective of region), hence it used to be easier. Now for all 4 weeks i have to make a common graph which will also indicate region so that region wise status is clear. Please advice how to fit all data in one graph yet highlight the region wise %.
Note: FD= project is planned to be tested in future weeks.
ProjIDS Region Week1 Week2 Week3 Week4
0.88 NA Pass FD Fail WIP
0.30 NA Fail FD Fail WIP
0.33 NA WIP FD Fail WIP
0.91 NA FD WIP Fail WIP
0.40 NA Pass WIP Fail WIP
0.93 EU Pass FD WIP WIP
0.99 EU Pass FD WIP WIP
0.92 EU Pass FD Fail WIP
0.61 INDIA WIP FD Fail WIP
0.01 INDIA Pass FD Fail WIP
0.68 INDIA Fail FD WIP WIP
0.45 INDIA Pass Pass WIP Fail
0.33 INDIA Fail Pass Fail Pass
0.86 INDIA Pass WIP Fail Fail
0.57 INDIA Fail WIP Fail Fail
0.96 INDIA Pass Pass Pass Pass
0.45 ASIA Fail Pass WIP Fail
0.47 ASIA Pass Fail WIP Fail
0.75 ASIA Fail Fail Pass Pass
0.52 ASIA Fail WIP Fail Pass
0.58 ASIA Pass WIP Fail Pass
0.72 ASIA Fail Fail Fail Fail
0.29 ASIA Pass Fail Fail WIP
0.58 ASIA Fail Fail Fail WIP
0.81 ASIA FD WIP Fail Fail
0.40 ASIA FD WIP Fail WIP
0.17 ASIA WIP WIP Fail WIP
0.91 ASIA WIP Fail Fail WIP
0.08 ASIA WIP FD Fail Pass
0.88 ASIA WIP Pass Fail Pass
0.44 ASIA FD Pass Fail Pass
0.36 ASIA FD Pass Fail Pass
0.76 ASIA FD Pass Fail FD
Already answered in another topic
http://www.excelexperts.com/region-wise-quarterly-summary-one-graph-data...