I have a numbers table with a bunch of values in a column, and a count of the respective value in another column. If I am plotting this in a chart, how can I make sure that the values in the one of the column (x-axis) is used uniquely?
Here is a simplistic example of what I have:
How can I make it so that the x-axis only show
Bananas as to bars, and the total count on the y-axis? Do I need to create a separate table to do that calculation and plot that table? Is there any better/elegant way of handling this? Basically I am looking for a way to get this chart: