do i need a macro for this pie chart?

  • Thread starter Thread starter morgan
  • Start date Start date
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
 
Back
Top