Enter the Graph Data
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:
- 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.
- Enter the data as seen in the image above into cells A1 to C6.