Skip to Content
Former Member
Jul 11, 2008 at 10:57 PM

Can a Pie Chart have a variable number of slices?


Is there a way to dynamically limit the NUMBER of slices that a pie chart shows?

For instance, sometimes there might be 10 elements, sometimes 6 (last 4 are 'blank') or maybe 5 (last 5 are blank).

Yes I know I can keep on reducing/increasing the Excel cells to include...but is there a way to include only certain ones as the data exists?