Pie chart-remove series w/out changing percent in pie
Is it possible to remove a series from a pie chart without the percentages of
each pie section changing? I tried to hide rows in the spreadsheet that have
<5 value. But I want the % in the data labels to stay the same. If I hide
rows, the labels change so that the whole pie still adds up tp 100%.
Thank you! Denise
|