Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm trying to set up an Excel chart. I've tried to enter 6 line feeds. I have followed the steps correctly, but on the graph it only shows 5 lines. On the right hand side listing of feeds it shows the 6 I want.

Is there a maximum number of feeds?

share|improve this question
    
that is singularly the most bizarre question i've heard yet. line feeds in excel charts? Do you mean data sets? –  Ahmed Masud Feb 2 '12 at 12:41
    
ok data sets.. the name you give to the line with the information being displayed.. I apologise for being less than a normal human being instead of an IT geek ;-) –  Barry Feb 2 '12 at 12:51
1  
Please be more specific about what you are trying to achive (possibly using common terminology). Maybe add a screenshot to clarify what you're trying to do. –  Oliver Salzburg Feb 2 '12 at 12:52
1  
@Barry no one's asking you to be an IT geek actually. All you have to do is use the terms that show up in the Excel itself (nowhere does excel use "line feeds" to refer to data). If you mean data titles then please use "title" ... Having said that the max number of items you can add to a graph is significantly more than 5. –  Ahmed Masud Feb 2 '12 at 12:58
    
ok.. I want a chart to show 6 'data sets'.. I have selected data range and 'add' etc within chart set up... the 6 data sets of info I want are shown on the rhs of chart by title.. but only 5 lines are shown on the chart?? Does this help?? –  Barry Feb 2 '12 at 13:00
show 2 more comments

1 Answer

There most likely is a limit to the amount of data series in an Excel chart, but I doubt it is as low as 5. Your lines are possibly overlapping.


As you can see here, there is no issue with 6 separate data series in a line chart:

6 data series in a line graph

However, if values overlap, only 5 lines are visible: 6 data series with overlapping data

share|improve this answer
    
Thanks Oliver ;-) –  Barry Feb 2 '12 at 13:07
    
Nice answer, Oliver. Barry, did Oliver answer your question? –  CharlieRB Feb 2 '12 at 13:49
add comment

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.