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?
ASKER CERTIFIED SOLUTION
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.
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.