Forum Discussion

josegovia's avatar
josegovia
Regular Visitor
9 years ago

Values in rows. Clustered bar chart

Hello

 

I want to add several variables to a bar chart. The variables contain values that are between 0 and 10, and I want the chart show the mean of each variable.

 

The label of each bar must be the name of the variable or a custom value, and the value must be the average of the values of that varibale.

 

For example, I have two variables, satisfaction and knowledge, with 300 cases each. And the values they contain are between 0 and 10.

 

I need a chart that contains two bars, with the mean of each variable and the labels of the bars being the variable title or a custom text.

 

Can it be done?

 

Thank you.

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    josegovia,

     

    Yes, you may add two measures and then drag them to Value.

    mean of satisfaction =
    AVERAGE ( Table1[satisfaction] )
    
    mean of knowledge =
    AVERAGE ( Table1[knowledge] )