text: how do you make a line graph on excel? i dont know how to plug in the data for the line graph to be made. and also, how do u find the 100 intercept? or any number intercept after you made the graph...  please help!! chart wizard... or 'insert' chart .  there's a default graph that comes up that i think is a bar chart, so just change the chart options to line graph and insert your numbers in the cells.