View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
IsaBeL IsaBeL is offline
external usenet poster
 
Posts: 13
Default Manual sort in a pivot chart/pivot table

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.

"Ann" wrote:

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?