Things You'll Need:
- Excel Book
- Microsoft Excel
- Microsoft Office
-
Step 1
Start Microsoft Excel, and open the file you want to use to make a chart.
-
Step 2
Drag the cursor over the columns you want to show in your chart.
-
Step 3
Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar.
-
Step 4
Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left.
-
Step 5
Press Finish if you do not want to label or format your chart.
-
Step 6
Press Next to label and format your chart.
-
Step 1
In the box that appears after you clicked Next, click the Series tab.
-
Step 2
Click on Series1, and enter a label for your data, such as "Number of Widgets per Month," in the Name field.
-
Step 3
Click on any additional series, and name those as well.
-
Step 4
Click Next.
-
Step 5
Select the Titles tab to label your chart and both its x-axis and y-axis.
-
Step 6
Select the Axes, Gridlines, or Legend tabs to format the look of your chart.
-
Step 7
Select the Data Label tab to label specific points on your chart.
-
Step 8
Select the Data Table tab to add a table of chart data under your chart.
-
Step 9
Click Next.
-
Step 10
Decide whether you want your chart on a new worksheet or on the same worksheet with your current Excel entries.
-
Step 11
Click Finish.







