Forum Discussion
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-msftCommunity 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.
- AnonymousNot applicable
I just used count of values becouse I'm trying to count repetition of data inside column