Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

This means that while the labels of 2 are shown, the labels of 3 are not. How can I 'hide' labels?

UPDATE: To clarify - how do I make the legend automatically disappear when it's a blank series, and appear otherwise?

share|improve this question
Do you mean you want to edit the legend? If you can, please put a screen shot so we can see what you mean? – Dave Sep 27 '12 at 13:13
oops yes - i mean hide the legends for some of them – daysandtimes Sep 27 '12 at 13:54
why the downvote?? - i want to have a variable number of time series in my graph, so some are blank series some of the time -that's why i asked this question – daysandtimes Sep 27 '12 at 14:07
-1, please edit your question to include all of the detail and revisions in your comments. Also, please provide some example of what you have or are trying to get, right now this is an erractically moving target. Case in point, both answers given so far (mine included) are to completely different questions (or interpretations of them). – dav Sep 27 '12 at 14:38

To add labels one series at a time, don't use the Ribbon Data Labels button. Instead

  1. Select a series you want the labels added to directly in your chart, then
  2. Right click for your context menu, then
  3. Choose Add Data Labels.
  4. Repeat as necessary.

Data Labels

You can also choose only a single data point to label, if you don't want to label the entire series.

share|improve this answer

Just single click on the legend text and delete it.

Update Based upon your new question, in your table try

enter image description here

As you can see, Cell A4 will display the series name (in this case Karl) providing all columns have data. The legend will still appear as a colour line, but no text will be associated (not sure if this is good enough).

share|improve this answer
Hmm ok upon second thoughts, how do I make the legend automatically disappear when it's a blank series, and appear otherwise? – daysandtimes Sep 27 '12 at 14:03
Use an IF statement in the field. So, if your row 2 had values, row 3 had values but row 4 didn't (where A2, A3 and A4 are the titles (series)) then do an if statement to check if any value is present and either display nothing or the series – Dave Sep 27 '12 at 14:06
how do i use an IF statement in the legend? – daysandtimes Sep 27 '12 at 14:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .