Forum Discussion
Post ProdigyDisplaying results by Question for multiple assessments
I am looking to display test results by Module Number and drill down to question. The columns are the question numbers with the specific performance for each question. I am looking for a simple column chart, but seems the best look in clustered column chart (in the attached). I don't like the look of clustered as some modules may have 80+ questions so having a legend will not be good to the eye. Want the Q1-Q8 (questions 1-8 as example) on the x-axis with the respective bars as the performance by question (in the attachment, excel screen shot). Any recommendations would be appreciated.
Hi jcastr02
If you'd like to set the Q1-Q8 as X-axis, you should put them under the same column, thus some transformation is needed for this scenario. Please share a sample of your data in a format that can be copied (paste it into the post from excel, not a screenshot) , then I'll draw it up for you.
3 Replies
- v-diye-msft
Community Support
Hi jcastr02
If you'd like to set the Q1-Q8 as X-axis, you should put them under the same column, thus some transformation is needed for this scenario. Please share a sample of your data in a format that can be copied (paste it into the post from excel, not a screenshot) , then I'll draw it up for you.
jcastr02Module Module Title Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 1 Calculations 0.733788 0.938567 0.918089 0.856655 0.846416 0.894198 0.938567 0.90785 2 Nonsterile Compounding 0.862069 0.948276 0.952586 0.844828 0.836207 0.788793 0.887931 0.87931 Below is a sample data. Q1-Q8 represents the questions with their respective scores. Thanks for your help v-diye-msft
- jcastr02
Thanks for insight. I've reorganized my raw data and it worked!