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?