• 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.

Dynamic chart for different categories

K

kaushik03

Member
Hi All,


I am trying to build a bar chart for which I require your assistance.


http://speedy.sh/ExpbA/Chart-Data.xlsx


At sheet1 Col A contains stakeholder’s name and Col B contains project rating given by them. Project rating ranges from X to 5 (X,1,2,3,3A,4,5) .In sheet2, I want to build a dynamic chart as follows:


1) Stakeholders who have given rating from X to 2(X,1,2)

2) Stakeholders who have given rating 3

3) Stakeholders who have given rating 3A

4) Stakeholders who have given rating from 4 to 5(4,5)


All the above 4 options should be in a drop down. Chart should be changed as user change the selection from drop down. X axis of the chart should have stakeholder’s name and Y axis should have feedback rating.


Now couple of points:


For option 1: There could be three bars (series) for each client (for rating X,1 or 2)

For option 2 and 3: For each client there should be only one bar

For option 4: There could be two bars (series) for each client (for rating 4 or 5)


Please note that, the original data set is huge. For each category, the number of unique stakeholders are somewhere around 60 to 70. So ideal approach would be to incorporate a scroll bar and make it link to the chart and show at the max 10 stakeholder's view at a time. As an when user hits the scroll bar, other bars in the chart should be populated.Or please feel free to suggest any other approach that might be more relevant in this scenario.


Please let me know how we can achieve this.


Kaushik
 
Hi Kaushik ,


You want two tasks to be done :


1. Interactivity in the form of a drop-down to change the series


2. Interactivity in the form of a scroll-bar to restrict the data points displayed say 10 at a time


Before these two tasks are taken up , can you develop just one chart , so that I can get an idea of how you want your chart to look ?


The data from your file is as follows ( I have sorted columns A and B on column B , using a custom list X,1,2,3,3A,4,5 ).

[pre]
Code: 
I	X
G	1
A	2
G	2
H	2
[/pre]
for the values X,1,2.


Using just this much of data , can you develop a sample chart and upload it ?


Narayan
 
Hi Narayan,


Thank you for your quick response.


Attached here is the sample chart.

http://speedy.sh/vGgKB/sample-chart-rating.xlsx


I am really not sure how to show rating which is presented in text form (like X or 3A)


As you see in the chart, there are 4 unique stakeholders. For G, we have two series (rating 1 and rating 2), for A and H, we have only 1 series (rating 2) and for I we have rating X and I really do not know how to reflect that in chart.


I completely rely on your thought/suggestion for the mode of presentation as long as all the info (the way I mentioned earlier) are visible.


Would that be helpful if I send you the original data?


Kaushik
 
Hi Kaushik ,


Before we get down to the nuts and bolts of implementing the chart , can you say what is the purpose of this chart ? To take the same data as in my earlier post , since G has 2 ratings of 1 and 2 , what would this signify ?


What does a rating of X signify ?


If the ratings are in the order X,1,2,3,3A,4,5 , would it make any difference if X were assigned a value of 0 , and 3.5 were used instead of 3A ? Could any scale from 0 to 100 be used ?


Narayan
 
Hi Narayan,


Actually this is the standardized project rating system we have in place.


X = Very poor

1 = Improvement is required

2 = Not upto the mark

3 = Good

3A = Good(But it's a system generated feedback when stakeholder do not provide any manual feedback)

4 = very good

5 = Excellent


The goal is to understand how stakeholders are giving feedback...who like our work and who did not like our work kind of .....


If there is no way we can present the alpha numeric rating (3A) or completely text rating (X) in the chart, then I believe we have to assign some numbers (like 0 for X and 3.5 for 3)....but that would be the last option we have to consider if the earlier one is really not possible in reality....


Looking forward to your response.


Kaushik
 
Hi Kaushik ,


I am working on a stacked column chart , which will show the frequency of the ratings each client has received.


Narayan
 
Ok looking forward to your output.


I am 100% sure that whatever you will do, will be awesome...


Thank you Narayan....


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