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.

By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

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.

Choose a line chart with markers to represent monthly sales. The resulting chart shown in Figure D is a bit cluttered, but this article isn’t about formatting the chart, so try to ignore that.

When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times. Be it sales data, client names, product segments, dates, or geographical ...

Line Charts: Best for displaying trends over time or continuous data. Use when you have a series of data points connected by straight line segments. Pie Charts: Suitable for showing parts of a whole.

Excel (2007) automagically grouped date and time on the X axis. Edit: I had time in the format of NN:NN. Excel doesn't know to combine date and time with a time format of NNNN.