bar chart

[Anonymous]

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 

[v-yuta-msft · Accepted solution]

@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]

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