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

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

If this suits:

Example chart


  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
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

You must log in to answer this question.

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