troubleshooting Question

Combine like values in a graph excel 2016

Avatar of BriPC
BriPC asked on
Microsoft OfficeMicrosoft Excel
7 Comments1 Solution1961 ViewsLast Modified:
In different data i have the same problem as this:
https://www.mrexcel.com/forum/excel-questions/218008-combining-like-values-pie-chart.html (example is from 11 years ago, hoping to find an answer..)

I have a column of category and in it contains various types repeated throughout my sheet.. I need to graph based on that column but i receive multiple outputs of the same category..

Example:
Column A --- Column B
"cat" 10
"Dog" 20
"Horse" 30
"Dog" 40
In the above example i want 3 categories in the chart showing percentages of the whole to be "Cat 10%", "Dog 60%", and "Horse 30%".

Instead what happens is i get 4 categories and Dog is repeated twice with percentages 20 and 40. How can i combine categories from column A that are the same value for my chart?

I've included the attachment of my sheet for reference ** My data for category is Hunting/Fishing, Garden, Electronic, Gun, etc***
snip-of-chart.JPG
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros