Google Sheets Charts – Prevent ‘Other’ in Legend

google sheetsgoogle-sheets-charts

When there are over 8 series in a chart (this is true at least for a pie chart) – Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 series… It could have just shown the last series instead of change the label to "Other".

Anyway, is there any way to stop this behavior manually?

The only solution I can think of is doctoring the image and replacing the "Other" with the label of the 9th series.

Edit: This behaviour doesn't happen anymore. No need for answers.

Best Answer

Comment

enter image description here

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
Related Topic