do i need a macro for this pie chart?

M

morgan

I have two columns with data that look something like:

1.5 A
1.0 B
0.5 C
2.5 B
1.0 C
0.5 A

A pie chart will currently (for the data set above) show
6 pieces of the pie. However, I just want a chart with 3
pieces...one for A, one for B and one for C.

Without adding new columns (which would get unweildly
with the huge number of lables), is there a way to get a
pie chart that automatically sums data that has the same
label?

If I need a macro, any ideas how I would go about
creating one?

Thanks a bunch!

Morgan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie of Pie Chart type with smaller pie showing slices of main slic 2
Pie Chart Not Charting Properly 3
How can I reset the default pie chart label "Other" to "Equity"? 1
Excel 3-D Pie Chart Flaw & Test 3
Pie Chart - Columns 1
Pie Chart displayed on top of a Pie Chart 7
Basic Categorical Pie Chart Question 2
Pie Chart values Automatic Update 0

Top