Spreadsheet: 215349d1361355093-prevents-line-graphs-plotting-zeros-workouttracker
Sheet: HowTo

 | [NAME]'s [NAME]
 | Feel free to redistribute this spreadsheet freely, just don't try to charge anyone for it.
 | I would love to hear your comments, suggestions, or other feedback!
 | [EMAIL]
 | HOW TO USE THIS [NAME]…
 | First, setup your exercises on the "Exercises" worksheet.
 |  | Column A contains the categories. If you would like to add additional categories, place them in the first empty row under column A.
 |  | All other columns contain the corresponding exercises. If you would like to add additional exercises, you will need to place them within the appropriate range.
 |  | The above picture shows that column B is highlighted and the range name is (circled in red) "Chest".
 |  | Therefore, to add additional "Chest" exercises, you would add the exercise to the first empty rown in column B.
 |  | If you choose add additional categories (in column A) you will need to create a corresponding range of exercises.
 |  | To create an additional range, scroll to the first empty column on the Exercises tab and begin entering your exercises. One exercise per row.
 |  | Once you have entered your exercises, simply click the column letter (B in the above image) to highlight the entire column.
 |  | With the entire column highlighted, enter the range name in the white box above column A (in the above image, the range has been named "Chest")
 |  | Note that your range name must match exactly the category name you entered in Column A
 | Once you have setup your exercises, you are now ready to track your progress.
 |  | Beginning with the worksheet titled "Week 1" you will find the following layout:
 |  | The first thing you should do is enter the week into cell B1.
 |  | Now you are ready to enter your exercises for the day. Notice in the above image, cell [NAME] has the day. Each worksheet has a section for each day of the week.
 |  | Begin by clicking on cell A5. You will notice a drop down arrow displayed to the right of the cell, as seen in the below image.
 |  | Click on this drop down arrow and a list of your categories will be displayed, as seen in the below image.
 |  | Select a category from the list.
 |  | Once you have selected a category, move right one column to cell B5.
 |  | Another drop down will be available in B5, this drop down will have a list of exercises from the category you just selected.
 |  | Now that you have selected your exercise, you are ready to enter your reps and weight.
 |  | Notice in the above image that there is a column for up to five sets plus an additional column for totals and notes.
 |  | You will only need to enter values into the Rep and Weight sub columns for the Set 1 through Set 5 columns.
 |  | Do not enter any data into the Total columns under each set or into any column on the Exercise Total heading as these values will be calculated for you.
 |  | Feel free to enter whatever data you would like under the Notes column.
 |  | Once you have entered all of your data, your row should look something like the following:
 |  | Notice that you are not required to enter data for all five sets.
 |  | Now just continue this for each day of the week.
 | Finally, the reason you are doing this, is to be able to track your progress.
 |  | On the worksheet titled "Progress", you will find two drop down values to choose in cell B2 and cell B3.
 |  | First, select a category in cell B2 and then select your exercise in cell B3.
 |  | Once you have selected an exercise, the data for all 12 weeks will be displayed to the right in a table format.
 |  | Note that data not yet entered will be displayed as 0.
 |  | In addition to the data being displayued in a table format, it will also be shown in three charts surrounding this data.
 |  | Enjoy!