how to show data labels in place of precodes

[rohitjmd]

i am working on questionnaire data, where i have few rating questions along with gender and age  information. in data file i have all the answers in form of precodes  rather than thier labels. is there any way i can show labels inplace of precodes in my charts. eg: i have 1 and 2 for gender. and 1 to 5 in rating questions. rather than 1,2 i want to show male and female on x axis. same i want to do in case fo rating questions. Also i cant replace my values with labels in data file as rating question analysis would be difficult in that case.

here is the sample data,

gender	Age	Q1	Q2	Q3
1	23	3	4	4
2	36	5	4	4
1	50	3	3	3
2	36	2	2	4
1	54	5	5	2
1	34	4	4	4
2	50	5	5	5
2	45	4	4	4
1	37	2	3	4

[v-yuta-msft]

@rohitjmd ,

i am working on questionnaire data, where i have few rating questions along with gender and age  information. in data file i have all the answers in form of precodes  rather than thier labels. is there any way i can show labels inplace of precodes in my charts. eg: i have 1 and 2 for gender. and 1 to 5 in rating questions. rather than 1,2 i want to show male and female on x axis. same i want to do in case fo rating questions. Also i cant replace my values with labels in data file as rating question analysis would be difficult in that case.

here is the sample data,

---

What's the logic if rating question analysis?  And could you post the expected result?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.