Sum Chart in Excel

Matt Pinkston
Matt Pinkston used Ask the Experts™
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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Hi Matt,

All you can do is, format your data as an Excel Table and insert a Pivot Chart as shown in the attached.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial