cancel
Showing results for 
Search instead for 
Did you mean: 

Can a Pie Chart have a variable number of slices?

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I apologize, I should have clarified in my previous response, the 'Ignore End Blanks' feature is only available in the Workgroup Desginer version and NOT the Standard or Professional versions for the purpose of creating dynamic ranges..fyi

Former Member
0 Kudos

Hello Terry,

In the properties/behavior tab of the Pie Chart, you can set 'Ignore Blank Cells' to true and the Pie Chart will only display the cells that contain values and ignore the null cells - thus having a dynamic range.

Thanks,

AJ

Former Member
0 Kudos

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