Well, the problem I have is that, as you can see, I'm a novice and I'm dealing with work done on charts by a previous designer. All the charts he worked on are in a PowerPoint file and so far I've added a placeholder for 2008 and I've experimented with resizing the charts and then adjusting the objects related to each chart. The charts they wanted cut in half to fit two slides have already been determined. The rest stay big. I can see from last year's PowerPoint show and last year's Word document that they have no problem displaying a lot of categories.
I do like your idea of doing all of this in Excel but that, I think, is beyond the scope of this project. There's too much here for me to come in and recreate in Excel. I'm not confident about that and there isn't enough time for me to do that. I think using the existing material and adjusting as needed is the way to go and I'm still struggling with how that will finally come about.
Looking at the Word 158 page final report from last year, there are about 16 fairly big charts ranging from 5 to 9 categories that cover years starting with 2004. They are given ample room, whether landscape or portrait. Looking at the PowerPoint 56 slide final presentation from last year, which is all landscape of course, there are about 7 big charts ranging from 7 to 9 categories. I see where some of these same charts display in landscape in PowerPoint and portrait in Word.
I've already played around with attempting to recreate one these charts within PowerPoint by following the specs in one of these charts and I'm getting odd results. So, that alone is very discouraging.