Welcome to Lesson 4 of the Basic Microsoft Excel Tutorial. In this lesson we will cover Charts. I hope you enjoy the lesson.

Charts

Step 1: Insert Chart

Select the cell where you want the chart to be inserted. Then select Insert and then Chart from the menu bar.

Step 2: Select Chart Type

Select the chart type that you want to use. Clicking on the different chart types will give you a basic description in the bottom-right corner. When you have selected your chart click next.

Step 3: Select Data Range

Select the range of data that you want to report on. You can also select whether the series is in the Rows or Columns.

Step 4: Select Option

Select the options for your chart. Based on which chart you chose you will access to different options. Some of the common options are titles, labels, gridlines, and legend. Most of these options give you a chance to change the text or to hide the option.

Step 5: Select Location

Select whether you want the chart to appear in a new worksheet or whether you want it to appear in the current worksheet. When you are done click finish to insert the chart into your Excel file.

Step 6: Finished

Your chart will now appear in Excel.