A little bit of context: initially there is a table, with column A, B, C. column C is a multi-select and might have up to 3 values, i.e. row 1 has value x in column C, row 2 - x,y, and row 3 - x, z, etc. I set this table to Bar chart view, with column C as the horizontal axis, and expect the vertical one show the counts for each value in this column. What I face currently is that the same values are not summarized, but shown as different items. Instead of having on the horizontal axis three items x,y,z and their corresponding count 3,1,1, I get as x=1, x,y=1, x,z =1.
Is there any way to set the bars in chart show the summary of each individual value if there is more than one in one table cell?
Hey @OYu ,
this would be a topic for the “Ask the community” category.
If not already done, convert your select list to a table and insert a number column with the formula
Then, create your chart from the second table.
Got it, will try do this way. Thanks a lot!