Manual sort in a pivot chart/pivot table


I

Isabel

My goal is to change the order of 4 row lablels. They are all text, and I
have to choose the order (not alphabetical).

I got as far as clicking on the arrow next to Row Label on the table, going
to More Sort Options and then choosing Manual Sort. HOWEVER, where/when do I
grab the labels to "drag" them to the right order? I have tried clicking on
the table itself and clicking on the chart but there is no dragging
happening. I can't find any detailed info on Manual Sort in the Help box, and
so I'm stuck.

Thanks in advance!
 
Ad

Advertisements

J

Jon Peltier

You can click on the cell containing label and drag it.

You can also select the cell where you want another label to appear,
type the other label, and press Enter.

- Jon
 
A

Ann

I am having the same problem but the reply to your message didn't help - did
you ever figure out how to drag to manually sort?
 
I

Isabel

Ann,

The previous post (the first reply to my initial message) was not very
helpful, since clicking on a cell does not allow me to subsequently drag it.
But I tried "cutting"the cell (ctrl+x) and "pasting" it in the place I wanted
it, even though there was another value already there. It worked! The old
value was pushed down the list automatically, and my pasted value was now in
the correct position.

I took a video to show it, in case my written explanation is not clear.
Anyone interested can email me for a copy. It's a short .avi video.
 
I

Isabel

Ok, I can't figure out quickly how to add my email to "About me" (when you
click on my name), so here it is for those interested in the demo video:

(e-mail address removed)
 
Ad

Advertisements

Joined
Jul 3, 2013
Messages
1
Reaction score
0
I had this same problem. You can do it without cutting and pasting:

1. In the pivot table, click only the cell of the heading you want to move.
2. Holding the mouse over the edge of that cell until you get the 4-header arrow, click and drag to the new desired position.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top