Thread: Set up Pivot Chart with multiple years

Hi

I am trying to work out the best way to set up a Pivot Chart using the following headings.... There are 800 students (rows)

ID, Year of Entry, Class, Level, 2001, 2002, 2003, 2004, 2005, 2006, 2007


Each Row is a unique Student, and the other data is as follows;
Year of Entry = 1998 - 2001
Class = Math, English, German etc...
Level = Honours, Advanced, Introduction

And for each of the "Year" columns (2001,2002 etc...), their could be grades such as Good, Exceeded, Outstanding, Average, No Rating.

So I think what I want to do is either have the User choose which "Year" of Grading to look at, or count how many "Good", "Exceeded" etc... for each of the "Years".

Thanks

Ronan

Yes, I see that. But I think what I need instead of simply the "Count" of the entries in each of the "Year" columns, 2001,2002,2003 etc, is to be counting how many Goods, Excellent, Exceeded etc.. for each "Year" column...

I have added a screen shot of how "I think" it would be...


Thanks

Ronan

Thanks Andy. I will have a play with that...

I might get way with the following (See Screenshot) Shame I need to repeat the Rows though as it's linked to an Access database... But I can set up a new "linked" sheet to that...


Regards

Ronan

Thanks Andy. Well, with Access, I'm really using Excel files dumped from Oracle, and then using those as tables within Access, relating them on the ID, as I have no control over Oracle.
I will have a re-think on how I can pull it diferently from Access.

Many thanks

Ronan

Actually Andy
Using your sample with the formulas, I have pulled it together.
Thanks so much for the advice.

Appreciate it

Ronan