Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

bar chart

when I'm trying to draw bar chart with more than column in excel it shown the last value entered 

 

as shown in figure below 

  • Anonymous ,

     

    It seems like the value is text format which can't be aggregated. Please change values to whole number and change the aggregation way from "last" to "sum".

     

     

    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.

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Anonymous ,

     

    It seems like the value is text format which can't be aggregated. Please change values to whole number and change the aggregation way from "last" to "sum".

     

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I just used count of values becouse I'm trying to count repetition of data inside column