Re: Problems Displaying Data
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Sun, 16 Apr 2006 07:47:18 -0500
You need one row of headers in your table. Each of those header cells cannot be
empty.
Make sure you don't have any empty cells in that header row.
Trickster wrote:
I tried that. I get the error: "The Pivot Table field name is not valid. ...
you must use data that is organized as a list with labeled columns .."
Since I have labeled columns, I am not sure what I am doing wrong there.
I've read the help on 'lists' and I suspect I don't have the table set up
right to do a pivot table, but heck if I can figure out from help whats
wrong about it, or how to fix it. It occured to me this morning that hiding
the top two rows (the week, which is combined cells covering three or 4
days) and the date (which I really don't need for my report/table) might
leave the "assignment" row as a valid column label .... apparently I was
wrong. LOL.
Any suggestions?
"Shellmarie" <Shellmarie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E807719-B346-4D88-A725-E5425950A81B@xxxxxxxxxxxxxxxx
Have you tried to the info in the file into a pivot table?
--
Shellmarie
"Trickster" wrote:
I think my main problem is I know so little about excel I don't even know
the right questions to ask. But here goes:
I have a grade sheet for 4 classes I teach, on 4 different sheets. The
first column in each sheet contains the student name, each column after
contains that student's scores on various essays/quizzes, etc The column
headers contain: 1st row, the "week"; 2nd row, the date; 3rd row, the
assignment name; 4th row the total points that assignment is worth.
under
that in each column begins the scores for each student.
| Week 1 | Week
2
| ......
| Date Date Date | Date Date
Date
| .....
| Assmnt Assmnt Assmnt | Assmnt ....
| Points Points Points | Points ....
Total Points possible
Student 1 | Points Points Points | Points ....
students Totals Final grade etc
Student 2 | Points Points Points | Points ....
What I WANT to do is generate a report (is that the term I want? ... or
do I
want to filter?) so that I end up with a table/report that looks
something
like this:
Students name
Assignment 1 (total points) Student's points
Assignment 2 (total points) Student's points
Assignment 3 (total points) Student's points
.........
total total percent
of
total points grade
I already have it calculating midterm grades, final grades, assigning
appropriate letter grades and flagging 'F's and 'D's in red and other
helpful things... I just can't figure out how to generate a %&#* report
for
each individual student.
Many thanks for any help anyone can give
Ed T
--
Dave Peterson
.
- References:
- Problems Displaying Data
- From: Trickster
- Re: Problems Displaying Data
- From: Trickster
- Problems Displaying Data
- Prev by Date: Building Math Graphs in Excel
- Next by Date: Re: merging worksheets
- Previous by thread: Re: Problems Displaying Data
- Next by thread: Re: Dates Changing Automatically When Copied
- Index(es):
Relevant Pages
|
