Excel dates, percentages and pie chart questions (2002)

I am new to Excel. I have a spreadsheet someone set up. I have to enter a lot of info into it for a court hearing in 2 days time and need to get it right. (Am using Excel 2002).

This spreadsheet concerns parental visits and is to show the percentage of whether the driver was late, who the driver was, if alternate drivers were used, if drop off was on time, if drop off was late, etc etc. The first column is the date. It’s set up for Fridays, which I need, but I also need to add Weds in there too (every other Weds) with an option to change to Thurs sometimes. Am not sure how to do this so it’s formulated correctly for percentages.

Each of the other columns for that date will have something entered to show if late, on time, who was driving, etc. The period will go back 18 months from the current time. I need to show the percentage of how many times they were late, how many times the driver was the mother, how many times alternate drivers were used, etc over the total 18 month period. There is a percentages column to the right of the spreadsheet that automatically configures things to percentages.

I’ve entered more dates but am not sure if I still have the correct formatting in the date column. Also, I’ve added some rows, and need to find out if the formatting is still OK in those new rows. It all needs to be right so it automatically works out percentages.

I also need to produce pie charts to give the judge an immediate view of percentages, and am not sure how to do this. Once I know the spreadsheet is OK, I have a ton of information to enter, and not much time.

Am not sure how to upload the spreadsheet. If it's possible to, it would only take a quick lookover. Because I am a new Excel user everything seems difficult to me, but I think my questions are probably very basic for regular Excel users.

If anyone can help me, I would be really, really grateful.

Thanks, Amy

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST