Hello all,
I feel very silly for this question, but here's my issue. I created a Pivot Chart, and I'm using TV dayparts as my rows. I'm using the titles for these dayparts (Morning, Daytime, Early Fringe, Prime Access, Prime, Weekend AM, Weekend PM, Total Day), and Excel 2007 auto-sorted these A-Z, which is not how I need them. I need them as they are listed, which is chronological according to the time of the day that they air.
I checked the "manual" setting under more sort options... and now I can't figure out how to drag and drop to re-sort my rows. Is there a particular part in the cell I'm supposed to be clicking on? Should I be sorting it somewhere else (not in the pivot chart itself?)
Thank you in advance for your help![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I feel very silly for this question, but here's my issue. I created a Pivot Chart, and I'm using TV dayparts as my rows. I'm using the titles for these dayparts (Morning, Daytime, Early Fringe, Prime Access, Prime, Weekend AM, Weekend PM, Total Day), and Excel 2007 auto-sorted these A-Z, which is not how I need them. I need them as they are listed, which is chronological according to the time of the day that they air.
I checked the "manual" setting under more sort options... and now I can't figure out how to drag and drop to re-sort my rows. Is there a particular part in the cell I'm supposed to be clicking on? Should I be sorting it somewhere else (not in the pivot chart itself?)
Thank you in advance for your help