Pivot Chart Report - formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

student Renee - 28 Sep 2005 16:16 GMT

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!

Reply to this Message

student Renee - 28 Sep 2005 16:35 GMT

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

> 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?
[quoted text clipped - 3 lines]
>
> Thank you!

Reply to this Message

Jon Peltier - 03 Oct 2005 12:05 GMT

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/
_______

> 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
[quoted text clipped - 8 lines]
>>
>>Thank you!

Reply to this Message