Home |
Search |
Today's Posts |
#1
|
|||
|
|||
changing column's order
i just posted a question on stacked alongside with regular columns, but
that's sorted. however now it seems like i can't change the order of the columns. i have one column with X and Y stacked and then Z alone. but i can't change it to Z alone and then X and Y stacked. i also have a dummy zeroed column that helps me have a beak between different observations. at this point it's like: X Y Z dummy X1 Y1 Z1 0 X2 Y2 Z2 0 i tried changing the series order (right click and then format data seriesseries order). but no matter the order i input, it always shows up X and Y column and the Z. i can only manage to change the stacked column, either placing X on top and Y on the bottom and the other way around. can someone help? ty in advance |
#2
|
|||
|
|||
Answered in your original thread.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ALVESM wrote: i just posted a question on stacked alongside with regular columns, but that's sorted. however now it seems like i can't change the order of the columns. i have one column with X and Y stacked and then Z alone. but i can't change it to Z alone and then X and Y stacked. i also have a dummy zeroed column that helps me have a beak between different observations. at this point it's like: X Y Z dummy X1 Y1 Z1 0 X2 Y2 Z2 0 i tried changing the series order (right click and then format data seriesseries order). but no matter the order i input, it always shows up X and Y column and the Z. i can only manage to change the stacked column, either placing X on top and Y on the bottom and the other way around. can someone help? ty in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the columns to copy | Excel Worksheet Functions | |||
how do i change order of columns in a list published to sharepoint | Excel Discussion (Misc queries) | |||
Changing the auto fill order from ascending to descending | Excel Discussion (Misc queries) | |||
changing the order shown in the save type menu | Setting up and Configuration of Excel | |||
How 2 reverse order of columns | Excel Discussion (Misc queries) |