Hello all,
I have created a pivot table where the Value Field Settings are set as "% of Row". The resultant table I am charting but I want the values to be sorted in the chart from left to right so I have 100% of one of the values in the column on the left, down to 0% of this value in the column on the right. This is intended to provide a clear view of the data rather than one where you need to keep inspecting the graph to see which ones have done better.
My problem is that I cannot sort the data in the pivot table. I can do this on other chart types using numbers but not on this 100% stacked column chart. What I have to do is manually reorder each row until I have them sorted, but for a large dataset this takes quite a while and I have lot of these graphs. I have attached an example image of the data I am trying to sort.. I hope this is clear, and that someone can advise how to do this.
Thanks
Paul.
Bookmarks