Introduction | Standard Toolbar | Formatting Toolbar | Navigating | Simple Formulas
Rows & Columns | Sorting | Cell Formatting | Charts

Chart Wizard:
Excel allows you to create basic – to – intermediate charts based off of information and data within your spreadsheets. Let’s create a column chart from the student grade data from before. First, highlight the data.

Next, select “Chart” from the “Insert” menu.

A new window will appear asking which type of chart you would like to create. For this example, let’s do a basic pie chart. Select “Column” from the “Chart Type” on the left side, and pick the first sub-type on the right (a normal, 2D column chart).

Click “Next.” In this window, you’ll be asked to select your “data range”; this is the area of your spreadsheet that you wish to generate a chart from. Since you’ve already selected the area before, it should already be entered into the appropriate area. “Series in” allows you to choose by which value you want to arrange the chart. Let’s arrange it by rows; this will break it down by “Grade” (such as Test 1, Test 2, etc.) and comparing the student scores next to each other.

Click “Next.” In step three you can give the chart a name (“Chart Title”), label the X and/or Y axis, etc.

Click “Next.” The final step will ask whether you want the chart as an object in your current spreadsheet or in a new one; generally, you will place it within the same spreadsheet.

Click “Finish,” and your chart will appear in your spreadsheet!