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.

My line plots the data series from 1999 to now. The other line I want to plot is about half a year in 2001. How can I insert this new line into the same graph I have for the other longer data series from 1999 to now.

share|improve this question

1 Answer 1

If this suits:

Example chart

then:

  1. Select source data (here A1:C20).
  2. Insert desired layout (here Charts, Line, Line with Markers)

rest should be automatic!

share|improve this answer
1  
If you go to the Edit Data dialog for the chart, click on Hidden and Empty Cells in the bottom left corner, and choose the Connect Points with Lines option, so there's no gap in the red lines of Series A. –  Jon Peltier Nov 27 '12 at 21:30
    
@JonPeltier Wow! THE Jon Peltier - sincere thanks for your phenomenal contribution to explaining the intricacies of charting and getting charts to 'jump through hoops'! Re gap - If to link up, in this case I'd cheat and simply put =B9 in C9 and then unfill that point. –  pnuts Nov 28 '12 at 1:59

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.