Hello this is my first time post so please bear with me if i did not clearly stated my problem. My question is regarding charting in excel where i have main category(SW rel) and sub category(Problem type seen in given sw release) that could have 3 different features where problem can be seen within subcategory. I have been trying to create stacked bar chart but i am not able to get this chart to show this information the way it needs to be plotted.
Here is what I am trying to display:
X-Axis Problem1,Problem2, problem3, etc.
There should be two Bar per problem1, problem2 for Release1 & Release2
where each release1 and release2 would have 3 stacked values of feature1, feature2, feature3.
Release 1 Release 2
Feature 1 Feature 2 Feature 3 Feature 1 Feature 2 Feature 3
problem 1 5 5 5 2 2 2
problem 2 1 1 1 6 6 6
problem 3 2 2 2 7 7 7
problem 4 3 3 3 8 8 8
problem 5 4 4 4 9 9 9
Thank you so much for your help in advance!
Here is what I am trying to display:
X-Axis Problem1,Problem2, problem3, etc.
There should be two Bar per problem1, problem2 for Release1 & Release2
where each release1 and release2 would have 3 stacked values of feature1, feature2, feature3.
Release 1 Release 2
Feature 1 Feature 2 Feature 3 Feature 1 Feature 2 Feature 3
problem 1 5 5 5 2 2 2
problem 2 1 1 1 6 6 6
problem 3 2 2 2 7 7 7
problem 4 3 3 3 8 8 8
problem 5 4 4 4 9 9 9
Thank you so much for your help in advance!
