Pivot Chart Report - formatting

I've selected TWO options that I put into my 'row' when I created this chart.
Is there any way I can reverse the way the two are appearing on the chart?
Current example: John's Best Dance Moves Kelly's Best Dance Moves

Desired example: Kelly's Best Dance Moves John's Best Dance Moves

Thank you!

p.s. - if it helps, it appears they're always in alphabetical order. But if
the boss wants me to duplicate his report - and it's for whatever reason NOT
in alpha order, can that even be done? And thanks to all of you once more!
-student Renee

"student Renee" wrote:

> I've selected TWO options that I put into my 'row' when I created this chart.
> Is there any way I can reverse the way the two are appearing on the chart?
> Current example: John's Best Dance Moves Kelly's Best Dance Moves
>
> Desired example: Kelly's Best Dance Moves John's Best Dance Moves
>
> Thank you!

The chart cannot perform any sorting between data and chart. You can
reverse the order of all items along an axis: Double click the axis,
Scale tab, Categories/Values in Reverse Order. But in general, you
should make sure the data is in the proper order in the worksheet before
committing them to a chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


student Renee wrote:

> p.s. - if it helps, it appears they're always in alphabetical order. But if
> the boss wants me to duplicate his report - and it's for whatever reason NOT
> in alpha order, can that even be done? And thanks to all of you once more!
> -student Renee
>
> "student Renee" wrote:
>
>
>>I've selected TWO options that I put into my 'row' when I created this chart.
>> Is there any way I can reverse the way the two are appearing on the chart?
>>Current example: John's Best Dance Moves Kelly's Best Dance Moves
>>
>>Desired example: Kelly's Best Dance Moves John's Best Dance Moves
>>
>>Thank you!