How to group non-numeric data?

[rasiel]

Hi, I'm new to the forum and have what is probably a newbie question.

I am looking to make a pie or pivot chart from a column that has been sorted from either-or string values. For example, if my workbook has a column with fruit names I would like to make the chart showing the percentage of apples vs. all other fruit and have all those other fruit types grouped together into one slice of the pie.

I know there's probably a number of ways of doing this but would appreciate any help.

Thanks,
Ras

[jeffreybrown]

Hello & Welcome to the Board,

How about you use CountA to count the fruits in column A and then use Countif to just get the count of Apples.

=COUNTA(A1:A10)
=COUNTIF(A1:A10,"Apples")

Then create the pie off of the formulas

[rasiel]

Hello & Welcome to the Board,

How about you use CountA to count the fruits in column A and then use Countif to just get the count of Apples.

=COUNTA(A1:A10)
=COUNTIF(A1:A10,"Apples")

Then create the pie off of the formulas

Jeff, thanks so much!

I wanted to not look stupid before asking again but I am a true-blue newbie in Excel! I can't have two formulas in the same cell so the way you're suggesting do I need to create two new columns with the one containing the countif referencing the first count? Not sure of the setup at this point but will keep fooling around... will likely learn something regardless :-)

Thanks again,
Ras

[jeffreybrown]

Hi Ras,

No problem. Look at this example...

Chart data comes from column D and E

[rasiel]

Awesome! Thanks so much for this!!

:-)

Ras

[jeffreybrown]

You are very welcome...glad it worked for you

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save