Forum Discussion

Matthias93's avatar
Matthias93
Helper III
9 years ago

No values on x-axis

Hi,

 

I'm trying to make a clustered colum chart, but I have no values on my x-axis. This makes that the bars of my chart are really close to each other and make for an ugly visual. My data is built up as follows: Answer 1 (Value) Answer 2 (Value)... The value ranges between 1 and 5 in whole numbers. On the x-axis I would like to have the different answers or questions and on the y-axis the average values per answer. Can somebody help me do this?

 

Thanks in advance,

 

Kind regards,

Matt

Need Help

2 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    Hi Matthias93,

     

    What's your data source looks like? Can you provide us some screenshots about your table?

     

    I have tested it on my local environment. My sample table looks like

     

    Drag QuestionNumber to Axis and drag Answer to Values, then change aggregate fucntion to average.

     

    Regards,

    Charlie Liao

    • Matthias93's avatar
      Matthias93
      Helper III
      9 years ago

      Hi v-caliao-msft here you can see a sreenshot of my data source. The problem is that the value and the question number are in the same column. Thank for helping!

       

      Kind regards,

      Matt