On 12 August 2011 14:43, Jean Brefort <jean.bref...@normalesup.org> wrote: > > We have several options: > > 1. don't display the series in the legend when it's name is actually an > error message such as "#N/A";
I can see this being useful -- you would be able to create a chart with several series and toggle the visibility of different series by using a formula for the cell with the series name, and having this toggle between #N/A! and the series title depending on other cells' values. > 2. don't display the series if all it's data are error values, even if > it's name is valid. IMHO this would be a bad idea, using error values for data values makes it easy to have null data points and even null data series; this could make the series vanish entirely. > 3. don't display the series when the series has no valid data. What's the difference between this and option 2? For 3 do you mean no valid data AND an invalid series name? > 4. always display the series, and rely on the user to uncheck the "Show > in Legend" box if he does not want to see it in the legend. This is simple and I don't think there is much wrong with it. - olly _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list