Current position:  Home > Default > Can a Pie Chart have a variable number of slices?

Can a Pie Chart have a variable number of slices?

Time:October 11
Advertisement
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?
Advertisement
My Behaviour tab for my pie chart does not HAVE the "ignore end blanks option"
A Pie chart behaviour only includes "Display Status, Display Status Key, Entry Effect, Entry Duration and "Animation Enabled"
I can't seem to find the "Ignore End Blanks" on any tab