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.

If I have a spreadsheet that has the following data:

   A       
0  0  
1  2  
2  4    
3  4    
4  6  
  • 0-4 X Axis
  • A is Y Axis

First point is (0,0)
Second Point is (1,2)
Third point is (2,4)
Last Point is (4,6)

I select my data and do -> Charts -> Line -> pick line from there, it draws the graph of this one table of values. When I draw a chart based on this I get my line correctly. How do I connect (0,0) with (4,6) in a straight line in excel? The reason I need it is because I have some other graphs that are going to be either in one or the other side of the connection line. I need to be able to demonstrate that.

share|improve this question

migrated from stackoverflow.com May 10 '11 at 14:06

This question came from our site for professional and enthusiast programmers.

1 Answer 1

You can add and format a new series on the chart with the data for the extra line. Depending on your needs (markers etc.), you might need to switch to an XY chart type.

If you do not want the new series to show up in the chart legend, then click on the new series name in the legend and press 'Delete'.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.