Create Graph

In this lesson, you are going to learn on how to create the graph from the data that had been input in the microsoft excel.

Create the graph

Click here for animated version

1. Select cells A2 to G6
2. Click the [Chart Wizard] Button

create graph

3. Choose color "line" for the chart type
4. Choose the sub type as shown in the image
5. Click the [Next] Button

create graph

"Chart Source data" window will be appeared
6. Click the [Next] Button

create graph

"Chart Options" window will be appeared
7. Write the "chart title", "category for x axis" and "category for y axis"
8. Click the [Next] Button

create graph

"Chart Location" window will be appeared
9. Click the [Finish] Button

create graph

10. The graph had been created on sheet 1

create graph

<< Fill background color of the cells | List of Excel Tutorials

Top