Hi I am wondering if someone can help me please.
I am doing analysis of responses to a number of questions from a customer base by age range.
I have the age ranges (16-26,27-37 etc) in the rows field. I have the responses to the question (one question per pivot) in the columns field.
The response to the questions typically have three responses - so ‘Does the customer need further advice?’ Might have the response Yes, Maybe, No. I have a count of each of the responses by age range and then do a % of row totals.
The problem I am having is that the response columns don’t appear in a consistent order from one question (and hence pivot chart) to the next. Furthermore they are typically not in the order that I want them in. So when I do a series of charts representing the questions I cannot produce the results in a manner that is easy to compare.
I am struggling to find a way that I can change the order of the columns so that they are consistent - perhaps with the most postive response first and the least positive last. Clearly sort isn’t going to work, so I was hoping there was a manual way of changing the order but haven’t been able to find it.
Any suggestions or advice greatly appreciated
Richard.
Have you tried this? Click on a column header for the response type. Hover the mouse over the edge of the cell until you see the 'four arrowhead' (PC) or the 'hand' (Mac). Click and drag the column to its correct position.
Hi Riny, Thanks for your response. I haven’t tried what you suggest and will do next time am in the office. I did try to cut and paste a column but got an error message telling me that I couldn’t do that in a pivot table. If I don’t get any further with your suggestion I’ll build a small mock data set to reproduce the issue and post. Thanks again.
I'm confident that it will work 
Hello Richard,
Riny's solution should help.
If you are still having issues, please paste a screenshot of your Pivot Table so we can best help you.
Thanks,
John
Hi Riny,
I have created a small dummy sheet and tried out your suggestion and it works as you knew it would. I can see the mistake I was making was trying to use the sheet column rather than the pivot column.
Thanks so much for your help!
All the best,
Richard.
Great!! Glad I could help.
R
