Displaying results by Question for multiple assessments

[jcastr02]

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.

[v-diye-msft · Accepted solution]

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.

[jcastr02]

Thanks for insight.  I've reorganized my raw data and it worked!

[jcastr02]

Module	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