Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I preserve data formatting in a pivot chart? | Charts and Charting in Excel | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
pivot chart formatting | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |