Bar chart - Average of categories

[shainis]

Hi, I'm trying to show the average of the categories, not of the answers.

For example, the average of the answers would always be 20%, because the total is 100%, divided by 5.

I would like however to show the average of the categories, based on the answers. So it would be 3.56 in this case. I would like a line that crosses the bar on 3.56.

My data is in excel that looks like that. Each line is a different submission in the questionnaire.

[v-yulgu-msft]

Hi @shainis ,

What does each row and each column mean in above sample dataset? How to generate the column chart based on such a sample table?

---

I would like however to show the average of the categories, based on the answers. So it would be 3.56 in this case. I would like a line that crosses the bar on 3.56.

---

What is the mathematical logic to calculate the result of 3.56?

Best regards,

Yuliana Gu

[shainis]

I managed to do so by changing the data type to decimal number instead of text.