Any M$ Excel (Office 2007) gurus out there?

[DaddyHoggy]

If yes read on:

Firstly, I'm sure this used to work in Office 97's version of Excel.

My problem - student feedback for a course is broken down per lecture (20 of them) as "Too much" "Just Right" "Too Little" (Technical content).

This data is displayed as a Stacked 3D columns with the hope that the data shows a nice big section of "Just Right" in the middle of some tail ends top and bottom of the other two.

So we can compare year on year improvements (or lack of them) for each lecture (and therefore each lecturer) the hope was to put data from previous years as a duplicate set of columns in front of the current year's data.

This used to be straightforward (I recall) in Office 97, but no amount of cursing, crying, dragging, dropping, adding, fiddling with chart/data ranges is getting the chart to do what I want it to do in Office 2007.

My Google-fu has also failed me and I can't find a solution, so I thought I'd try "Oohay!"

Any thoughts, solutions, URLs would be much appreciated.

DH

[Selezen]

I'm normally pretty good at Excel voodoo, but I would need to take a look at your charts and tables to see what you are doing and try to work out what's going on.

"Need INPUT!"
- Johnny 5

[DaddyHoggy]

I'll put it up on Box and send you the link via PM - thanks Selezen!!!

[maik]

You can send it over here, too. I spend way too much of my work time in Excel...

[drew]

If those kind gents can't solve, I'll give it a whirl too.

Cheers,

Drew.

[PhantorGorth]

I am willing to wade in if any further help is required. Though I only know Excel up to version 2003 but hopefully the stuff like basic charts hasn't changed much in 2007 compared to 2003 (and I don't mean interface changes)

[maaarcooose]

I presume you're using pivot tables and charts?

!m!

[Selezen]

<waiting for PM>

[DaddyHoggy]

Waiting for chance to upload data to Box!

<grabs coffee and heads back to lecturer theatre>