Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

Sum Chart in Excel

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
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial