Thread: rearranging chart

Hi, I've got a chart like this:

http://img217.imageshack.us/img217/1962/chartet9.jpg

and I want to re-arrange it so that the module 1 results are next to each other, module two results are next to each other, etc, giving:

Code:

Engineering Technology  Engineering Technology
|       Module 1      |       Module 2       |   etc...

But I couldn't find a way to do it in the chart options. Can anyone help?

Hi,

Jon Peltier has just covered something like this in his blog

http://peltiertech.com/WordPress/200...-pivot-tables/

Check it out. You need to rearrange the order of the categories in your pivot table.

cheers

Teylyn