Changing Order of Stacked Column Pivot Chart

[PunPryde]

I have a pivot chart with stacked columns that I need to change the order of (ie. move top stack to the bottom). How can I do this in Excel 2007?

Thanks!

[day92]

Pun can you upload a sample pivot chart of what you are referring to?

[PunPryde]

Pun can you upload a sample pivot chart of what you are referring to?

I just needed to move the data around in the originat pivot table, thanks though!