Comment

Example

I've created an example file for you: how do I prevent “Other” in the legend?

Comment

Example

I've created an example file for you: how do I prevent “Other” in the legend?

Update

I've done some research and found out the following in which the behavior can be resolved if shown:

1. Choose an exact range in the chart: I2:I107
2. Delete the remaining empty rows, in your sheet