Boot up your computer.
Launch "Excel."
Click the "Office Button" at the top-left side of the window. Select "Save As." Save the file as the name of the student and in the desired directory location. Click "Save."
Enter the name of each project or assignment that the student has completed or will be completing in the future that you wish to keep track of. The names should be listed in the first column starting in cell A2.
Enter the period of time that you wish to keep track of. The time periods can include weeks, months, quarters, semesters, trimesters or yearly options. The time periods should be listed in the first row starting in cell B1.
Click the "Insert" tab in the Ribbon. Click the small arrow in the bottom-right corner of the Charts section.
Review the type of charts available by selecting from the menu on the left of the pop-up menu. Choose the desired chart type by clicking the choice in the left column.
Select the display option from the selections to the right of the pop-up menu.
Click "OK" to create your chart. A chart will automatically display with your information.
Adjust the size of your data selection field by hovering your mouse over one of the squares bordering your data field until a double-sided, diagonal arrow appears. Click the left side of the mouse and adjust the data box by dragging the mouse and releasing the mouse button. Adjust the size of your chart using the same method.