• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Region wise quarterly project summary (plot 4 reg 4 week's prj stat in 1 graph)

H

henna78

New Member
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.

[pre]
Code: 
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
[/pre]
 
This topic is the same as last question of this, just a day of difference:

http://chandoo.org/forums/topic/need-to-plot-4-regions-4-weeks-project-status-in-one-graph


What you're doing "is called cross-posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered. You should also check and respond to posts and let posters know if they are heading in the write direction or not." Hui's dixit, SIC. And I agree 101%.


If you'd have read the main green sticky post at this forums main page...

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

...you should have noticed this points:


"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."


"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."


"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker."


"If you do cross post, please put that in your post."


"Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."


"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."


"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."


Title edited.
 
Henna78


In addition to SirJB7's comments above:


You are asking for a chart with data plotted by month

But there are no date data in your list above?


Can you post a sample file, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi SirJB7 & Hui, i am new here and was not able to edit the subject, thats the only reason for multiple post, i will delete old one if no replies already and if i have right to delete.


At the moment, i am in office and don't have much of acces hence not able to upload sample document on which i have already worked. I will do that ASAP.

But in summary, the data i have pasted in request mail i.e. Columns (ProjIDS, Region, Month1, Month2, Month3, Month4) is what is crux of the result needed.


any help or diea to resolve will be appreciated.


Thanks...
 
You must log in or register to reply here.
Back
Top