Stacked column chart showing wrong valued

[Lincy]

i created a stacked column chart for 25 students with 3 different assessment scores. all the columns in the chart is showing the same values for all students. how to rectify this.

[Bibiano_Geraldo · Accepted solution]

If you're using two different tables for axis x and y, make sure are they related.

[Lincy]

@ChiragGarg2512 got it. Thank you so much.

[Lincy]

@ChiragGarg2512 This is the data for different trainees. i want the average of scores in all 3 stacks. Example, the first trainee should get the values as 91,71, 83 and the second trainee should get 74,93,82. But i am getting 58,62,56 for all trainees.

[ChiragGarg2512]

@Lincy Can you elaborate on the issue with column/measure formulas and some sample data.