Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
2  
Can you share the sheet so we can take a look at it? – William Feb 7 '13 at 16:36
up vote 1 down vote accepted

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
share|improve this answer
1  
Thanks for answering this really old question! The behaviour I was struggling with doesn't happen any more. Google Sheets have evolved considerably in the last couple of years... – NoamNelke Sep 21 '15 at 9:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.