Link to home
Avatar of TheBigDog
TheBigDog

asked on

Group same values in Excel Chart Legend

Hopefully this is an easy question. I have a simple pie chart in excel, with a legend. The legend data series contains only 4 values. Let say Spring, Summer, Fall Winter. But I have more than 4 rows of data. The legend displays an entry for each value in each row. Is there an easy way for it to only show the 4 values, and add up the weights on the pie chart?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of andreyman3d2k
andreyman3d2k

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of TheBigDog
TheBigDog

ASKER

Yes thats exactly the chart I want to have. The problem is the subtotal data is hidden. I would like to print the summary for the chart, but still retaining on the detail of the data.
Avatar of Tracy
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.