Tweet
Line Graph in Excel
No matter what type of chart or graph you are creating, the first step in creating an Excel chart is always to enter the data into the worksheet.
When entering the data, keep these rules in mind:
Don't leave blank rows or columns when entering your data.
Enter your data in columns.
When laying out your spreadsheet, list the names describing the data in one column and, to the right of that, the data itself.
If there is more than one data series, list them one after the other in columns with the title for each data series at the top.
No matter what type of chart or graph you are creating, the first step in creating an Excel chart is always to enter the data into the worksheet.
When entering the data, keep these rules in mind:
Don't leave blank rows or columns when entering your data.
Enter your data in columns.
When laying out your spreadsheet, list the names describing the data in one column and, to the right of that, the data itself.
If there is more than one data series, list them one after the other in columns with the title for each data series at the top.