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:

enter image description here

How can I make it so that the x-axis only show Apples and 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:

enter image description here

You must log in to answer this question.

Browse other questions tagged .