Region Wise Quarterly Summary as one Graph - Data Attached - Please help/advise
Dear experts, My data is as follows, please suggest me how to plot summary in just one graph.
The graph should show for each region, in each month how many Project IDs were success (Pass), Fail, FD (Marked for future implementation), and are WIP (in progress).
My mind is not functioning as to how without copy paste we can use this data and convert into one graph. I tried pivot->graph but did not get desired results.
ProjIDS Region Month1 Month2 Month3 Month4
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
Re-arrange your columns like this
Hi Henna,
In order to get pivot table in form that you like, you need small re-arrangmment: statuses by month should be one below each other.
Rename column "Month1" to "Month".
Copy columns ProjID and Region 3 times downwards (for each month).
In column "Month" copy/paste statuses for each month.
You should get a table like this:
ProjIDS Region Status Month
0.88 NA Pass Month1
0.30 NA Fail FD Month1
0.33 NA WIP Month1
0.91 NA FD Month1
0.40 NA Pass Month1
0.93 EU Pass Month1
0.99 EU Pass Month1
0.92 EU Pass FD Month1
0.61 INDIA WIP Month1
0.01 INDIA Pass Month1
0.68 INDIA Fail FD Month1
0.45 INDIA Pass Month1
0.33 INDIA Fail Pass Month1
0.86 INDIA Pass Month1
0.57 INDIA Fail WIP Month1
0.96 INDIA Pass Month1
0.45 ASIA Fail Pass Month1
0.47 ASIA Pass Month1
0.75 ASIA Fail Fail Month1
0.52 ASIA Fail WIP Month1
0.58 ASIA Pass Month1
0.72 ASIA Fail Fail Month1
0.29 ASIA Pass Month1
0.58 ASIA Fail Fail Month1
0.81 ASIA FD Month1
0.40 ASIA FD Month1
0.17 ASIA WIP Month1
0.91 ASIA WIP Month1
0.08 ASIA WIP Month1
0.88 ASIA WIP Month1
0.44 ASIA FD Month1
0.36 ASIA FD Month1
0.76 ASIA FD Month1
0.88 NA FD Month 2
0.30 NA Fail Month 2
0.33 NA FD Month 2
0.91 NA WIP Month 2
0.40 NA WIP Month 2
0.93 EU FD Month 2
0.99 EU FD Month 2
0.92 EU Pass Fail Month 2
0.61 INDIA FD Month 2
0.01 INDIA FD Month 2
0.68 INDIA WIP Month 2
0.45 INDIA Pass Month 2
0.33 INDIA Fail Month 2
0.86 INDIA WIP Month 2
0.57 INDIA Fail Month 2
0.96 INDIA Pass Month 2
0.45 ASIA WIP Month 2
0.47 ASIA Fail Month 2
0.75 ASIA Pass Month 2
0.52 ASIA Fail Month 2
0.58 ASIA WIP Month 2
0.72 ASIA Fail Month 2
0.29 ASIA Fail Month 2
0.58 ASIA Fail Month 2
0.81 ASIA WIP Month 2
0.40 ASIA WIP Month 2
0.17 ASIA WIP Month 2
0.91 ASIA Fail Month 2
0.08 ASIA FD Month 2
0.88 ASIA Pass Month 2
0.44 ASIA Pass Month 2
0.36 ASIA Pass Month 2
0.76 ASIA Pass Month 2
0.88 NA Fail Month 3
0.30 NA WIP Month 3
0.33 NA Fail Month 3
0.91 NA Fail Month 3
0.40 NA Fail Month 3
0.93 EU WIP Month 3
0.99 EU WIP Month 3
0.92 EU Pass WIP Month 3
0.61 INDIA Fail Month 3
0.01 INDIA Fail Month 3
0.68 INDIA WIP Month 3
0.45 INDIA WIP Month 3
0.33 INDIA Pass Month 3
0.86 INDIA Fail Month 3
0.57 INDIA Fail Month 3
0.96 INDIA Pass Month 3
0.45 ASIA Fail Month 3
0.47 ASIA WIP Month 3
0.75 ASIA Pass Month 3
0.52 ASIA Pass Month 3
0.58 ASIA Fail Month 3
0.72 ASIA Fail Month 3
0.29 ASIA Fail Month 3
0.58 ASIA WIP Month 3
0.81 ASIA Fail Month 3
0.40 ASIA Fail Month 3
0.17 ASIA Fail Month 3
0.91 ASIA Fail Month 3
0.08 ASIA Fail Month 3
0.88 ASIA Fail Month 3
0.44 ASIA Fail Month 3
0.36 ASIA Fail Month 3
0.76 ASIA Fail Month 3
0.88 NA WIP Month 4
0.30 NA Month 4
0.33 NA WIP Month 4
0.91 NA WIP Month 4
0.40 NA WIP Month 4
0.93 EU WIP Month 4
0.99 EU WIP Month 4
0.92 EU Pass Month 4
0.61 INDIA WIP Month 4
0.01 INDIA WIP Month 4
0.68 INDIA Month 4
0.45 INDIA Fail Month 4
0.33 INDIA Month 4
0.86 INDIA Fail Month 4
0.57 INDIA Month 4
0.96 INDIA Pass Month 4
0.45 ASIA Month 4
0.47 ASIA Fail Month 4
0.75 ASIA Month 4
0.52 ASIA Month 4
0.58 ASIA Pass Month 4
0.72 ASIA Month 4
0.29 ASIA WIP Month 4
0.58 ASIA Month 4
0.81 ASIA Fail Month 4
0.40 ASIA WIP Month 4
0.17 ASIA WIP Month 4
0.91 ASIA WIP Month 4
0.08 ASIA Pass Month 4
0.88 ASIA Pass Month 4
0.44 ASIA Pass Month 4
0.36 ASIA Pass Month 4
0.76 ASIA FD Month 4
Create pivot table and graph.