Creating a line chart in Excel takes four steps: select your data, open the chart menu, choose the line chart type, and place it on your sheet
A line chart shows how something changes over time — sales by month, temperature by day, website visits by week. Excel builds the chart automatically once you tell it which numbers to use and where to put the lines. You do not need to know formulas or special skills. The chart updates itself if you change the numbers later, so you can keep the same chart as your data grows.
This guide walks you through creating a basic line chart, then shows you how to add titles, change colors, and move the chart where you want it. If your data is already organized in columns or rows (which it should be if you followed the filing guide), you are ready to start.
Key Takeaways
- Select the cells that hold your data before you insert a chart — Excel uses the selection to know what to plot.
- The first row or column should contain labels (like "January", "February") so Excel knows what to call each line or point.
- A line chart works best when one column holds dates or time periods and other columns hold the numbers you want to compare.
- After you create the chart, you can change the title, add axis labels, and move it to a different sheet without losing the data.
Organizing your data before you start
Excel needs your data arranged in a specific way to build a chart correctly. Put your time periods (months, years, weeks) in the first column going down, and put the numbers you want to track in the columns to the right. For example, if you are tracking sales for two products over six months, your first column would be the month names, your second column would be sales for Product A, and your third column would be sales for Product B.
Include a header row at the very top with labels like "Month", "Product A Sales", and "Product B Sales". Excel uses these labels to name the lines on your chart and the axes. If your data does not have headers, Excel will use generic names like "Series 1" and "Series 2", which makes the chart harder to read.
Make sure all the numbers in each column are actually numbers, not text that looks like numbers. If a cell contains an apostrophe before the number (like '100), Excel treats it as text and will not plot it correctly. Delete the apostrophe and re-enter the number if this happens.
Selecting your data and inserting the chart
Click on the first cell of your data (usually the top-left cell with a header) and drag to the last cell that contains data. This selection should include all your headers, all your time periods, and all your numbers. You can also click the first cell, hold Shift, and click the last cell to select the range without dragging.
Once your data is selected (you will see a colored border around it), go to the Insert tab at the top of the Excel window. Look for the Chart button — it usually shows a small bar chart icon. Click it, and a menu will appear showing different chart types.
Find Line Chart in the menu and click it. Excel will show you several line chart styles — the first one (a straightforward line with points marked) works for most situations. Click the style you want, and Excel will insert the chart into your sheet. The chart appears as a box with your data plotted as lines.
Adding a title and axis labels
Click on the chart to select it — you will see a border around it and three buttons appear to the right. The top button looks like a plus sign and is labeled Chart Elements. Click it to open a menu of things you can add to your chart.
Check the box next to Chart Title to add a title at the top. A text box will appear that says "Chart Title" — click on it and type your own title, like "Monthly Sales by Product". Check the box next to Axis Titles to add labels to the left side (vertical axis) and bottom (horizontal axis). Click on each axis title that appears and type what that axis represents, like "Sales in Dollars" or "Month".
You can also check Legend to make sure the legend (the box that explains which line is which product) is visible. If the legend is already showing, you can leave this unchecked. Close the Chart Elements menu by clicking elsewhere on the sheet.
Moving and resizing your chart
Click on the chart and drag it to move it to a different location on the same sheet. If you want the chart on a different sheet entirely, right-click the chart, choose Move Chart, and select the sheet you want. This is useful if your data sheet is crowded or if you want to keep data and charts separate.
To resize the chart, click it and drag one of the small squares at the corners or edges. Dragging a corner square keeps the chart proportional. Dragging an edge square stretches it in one direction. Make the chart large enough to read the labels and see the lines clearly, but not so large that it takes up your entire sheet.
Changing line colors and styles
Right-click on one of the lines in your chart and choose Format Data Series. A panel will open on the right side with options to change the line color, thickness, and style. Click the paint bucket icon to change the color, or click the line icon to make the line thicker or add dashes to it.
If you have multiple lines (one for each product or category), you can format each line separately. Right-click the specific line you want to change, and the same panel will open for just that line. This lets you make Product A's line blue and Product B's line orange, for example, so they are easier to tell apart.
Updating your chart when data changes
If you add new numbers to your original data, the chart does not automatically include them. You need to tell Excel to include the new cells. Click the chart, and a colored border will appear around the data it is using. Drag this border to include your new data, or right-click the chart, choose Select Data, and manually enter the new range of cells.
If you only change the numbers that are already in the chart (like updating last month's sales figure), the chart updates when ready without any extra steps. This is why organizing your data carefully at the start saves time later — you can keep adding new months to the same columns, and the chart will always show the current data.
Frequently Asked Questions
What if my data is arranged in rows instead of columns?
Excel can handle data arranged either way. When you select your data, Excel usually figures out the correct orientation automatically. If the chart looks wrong (with months as separate lines instead of points along one line), right-click the chart, choose Select Data, and click Switch Row/Column to flip how Excel reads your data.
Can I create a chart with data from two different sheets?
Yes, but it is more complicated. Select the data from the first sheet, insert the chart, then right-click the chart and choose Select Data. Click Add to add a data series from the second sheet. You will need to type the sheet name and cell range manually, like Sheet2!A1:A12. For most situations, copying the data into one sheet first is simpler.
How do I delete a chart I no longer need?
Click the chart once to select it, then press the Delete key. The chart disappears, but your original data remains untouched. Charts are separate objects in Excel, so deleting a chart never affects the numbers it was based on.
Why does my chart show a flat line instead of ups and downs?
This usually means Excel is treating your numbers as text instead of actual numbers. Check that your data cells do not have apostrophes before the numbers, and that you have not accidentally typed a space or letter in a cell that should contain only a number. Click the cell, look at the formula bar at the top, and fix any text that should be a number.