A chart is a very clear visual presentation of data. This tool can say a thousand words. In five easy steps you will be ready to show your data!
1. Select the data to be illustrated. Click and drag through the cells that you want included. However, sometimes there is more information in your table then you want in your chart. So you can select nonadjacent cells by clicking in the first cell you want, holding a finger on the "Control (Ctrl)" key and moving to the next cells you want. You finger does not leave the control key until all desired cells are selected. Then click on the Chart Wizard button.
|
 |
2. Choosing the chart type is the next step. Many choices are available but remember the goal is for clarity, therefore pick the easiest to understand type. To help you make that decision, Excel has put a "Press and Hold to View Sample" button on this screen. It will give you a chance to preview the display of your data. If it looks clear, click "Next" to go to step 2 of 4 .
|
 |
3. This step show the look of the graph. As you can see, the data "Series in:" is for "Columns". If that is not the exact look you want, Change to "Series in: Rows". It will then present the same information from a different perspective. See which is the most accurate portrayal of the information. Then click "Next".
|
 |
4. This window allows you to enter the "Chart Title", the "Category (X) axis:" and the Value (Y) axis:" Choose the labels that will most accurately describe your chart. Then click "Next".
|
 |
5. Here you determine where you want to place the finished chart. Do you want it to be on a page by itself fill an 8.5" x 11" paper? If so, click "As new sheet:". If you want this chart to be with the data it is explaining or want more than one Chart on the page; click "As object in:" and the chart will become a part on the worksheet on which you were working.
|
 |
| Congratulations! If your project looks like the one below, you have successfully completed this tutorial. If not go back and check for errors. If after checking you still have problems, attach your chart and send it to me for help. Help Please! |

If you are still struggling there are excellent video clips that also teach Excel at the Atomic Learning site. This is a subscription site but District 200 pays for this for all students, staff, and district families. The log-in information is available at the building libraries.
Almost Finished
The following is a check list if you want to see if all parts of the example were followed correctly. If you did well, and I assume you did, congratulations! You are ready for the real world in the classroom with your new friend, Excel, to help make your life easier.
Grade Book Rubric (checklist) |
| Formatting |
|
|
| |
Titles Bold |
| |
Data Centered |
| |
Borders around Data |
| |
Columns widen for data or text wrapped |
| |
Student Names sorted with appropriate scores |
| |
Row added for Points per Assignment |
| |
Assignment totals included |
| Formulas |
|
| |
Average per assignment |
| |
Average for Class |
| |
Totals # of points per student |
| |
Percent (in Decimal form) for each student |
| Chart |
|
| |
Correct cells selected (for illustration A1:A8, F1:F8) |
| |
Chart Titles included |
| |
X and Y axis labeled |
| |
Chart enlarged to view all data |
| |
Chart below data |
Back to top
|