I have a pivot chart displaying a number of products on the x-axis and the count (number of) on th Y axis. What i want to do is somehow control the order that the x axis lists the values along the bottom. When i produce the pivot chart the values are listed in alphabetical order. I was wondering if anyone knows how to change the order the values appear into something else.

any help appreciated. Cheers