troubleshooting Question

Sum Chart in Excel

Avatar of Matt Pinkston
Matt Pinkston asked on
Microsoft ExcelMicrosoft Office
1 Comment1 Solution123 ViewsLast Modified:
Fairly new to excel charting and I am trying to create a chart off a sheet that has many tabs but only want to chart of two tabs and get a pie summarized chart.

Data Sample
Column A    Column B
Red               10
Blue              5
Green           3
Red               7
Purple          4
Red               3

So on my Pie I should see four slices
Red 20
Blue 5
green 3
purple 4

how is this achieved?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
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 1 Comment.
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