Joined: 10 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 2
Topic: stacked bar chart Posted: 10 Nov 2009 at 10:40am
hi could someone kindly give me some pointers please.
i have the results from 8 people who were asked a series of questions. each answer was from 1-5.
what i need is a stacked bar graph. 1 bar for each question with the total for each question determining the height. but what i cant do is to make the bar show how many of each answer number there was e.g.
q1 answers - 5 5 4 2 2 2 1 1 . total bar height 22 made up of 5 segments showing that there were 2 1's etc.
Joined: 10 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 2
Posted: 11 Nov 2009 at 1:27pm
hi
thanks for responding. In my access dbase i have the data as in your first example.
though in my trials to find a solution i have it in excel as the first, but also additional fields such as countIF for each answer number which returns how many of each answer i get.
i actuall dont need to track the people at all, it is the answers, and how many of each answer i get, how many 1's 2's etc.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 11 Nov 2009 at 2:52pm
Hmmm,
Was hoping it was the second. It is easier. In the Chart Expert you would set to On Change Of first as Question field and Second as Answer Field. Then you can set the Show Values as either a count of Person or a SUM of Answer depeding on which way you want to look a the data.
What does the source data look like and are you married to the stacked bar chart or open to alternatives?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
