How to make a line graph in Excel 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight ...

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

Excel's functionality includes chart options you can insert to add a title directly onto a line graph, so that you don't have to insert extra text boxes or type into the cells around the graph.

Go to the Insert tab and insert a 2-D line graph. Right-click on the line and select the Format Data Series. Go to the Fill & Line tab. Check the Smoothed line option.

Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend.

Right now, the line chart doesn’t display the Emphasis series — the value $1,800,000 — as a vertical bar. It’s a round marker. The blue marker is there, but you can’t see it.

In this tutorial, I’ll show you how to create a burndown chart in Excel and discuss what each line shows in regard to scheduling and meeting deadlines. Download the demo files.

I just tried this. Select all the data you want to have graphed, click on Insert, pick line graph, and choose which one you want. Excel (2007) automagically grouped date and time on the X axis.