How to sort data by value and keeping the original label
I want to sort my columns in accordance to their height, and not the label. How do I do that?
First I start of making the columns. Here is the percentage of sick leave in the different counties in Norway, first quarter of 2007 in Norway:
Here they are, as you see, sorted alphabetically by the name of the county. Nice and dandy, but imagine we are to compare two data series, i.e. to look for correlations. Then we may need to sort the bars by their size in one of the series instead. How to do that?
First, we set the chart type to be Scatter.
Then we set the same value in the x and y axis, both Avg:
The following graph should appear:
Not very informative, but we are not quite done yet :-)
Set the type back to Vertical again:
You may want to set the plot type to Bar again, and turn off markers:
Then we should have a nice graph, sorted by the value!
When copying the strange script from Advanced tab in the properties of the sorted graph, and pasting that into the Advanced tab in the properties of the unsorted graph, that as well get sortet! (Ceteris paribus).