How to create pie chart from 1 column with duplicates

[Tyrel Smith]

Could someone please help me.

I'm trying to create a pie chart from only one column which has duplicates, I want it to display the name of the item and how many duplicates there are of it. Se below

Apple

Mac

Windows

Apple

Mac

Apple

Mac

Please help.

 

[6StringJazzer]

I am not up on all the new features in 365 although that's the version I have. I will check these out. (Tyrel Smith's profile shows 2010, however.)

How does the "#" function in those formulas?

 

[tusharm]

I am not up on all the new features in 365 although that's the version I have. I will check these out. (Tyrel Smith's profile shows 2010, however.)

How does the "#" function in those formulas?

Spilled range operator - Microsoft Support

Learn how to use the spilled range operator to return a spilled array range in its entirety.

support.microsoft.com

 

[Peter_SSs]

365 although that's the version I have. .... (Tyrel Smith's profile shows 2010, however.)

.. and your profile shows 2019.

 

[6StringJazzer]

.. and your profile shows 2019.

Whoops! Just upgraded recently, gotta fix that.