Fra mn/ifi/camsem
Revisjon per 8. jul. 2010 kl. 08:05 av Larsereb@uio.no (diskusjon | bidrag)

(diff) ← Eldre revisjon | Nåværende revisjon (diff) | Nyere revisjon → (diff)
Hopp til: navigasjon, søk

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:

Tutorial 5 bilde 1.JPG

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.
Tutorial 5 bilde 2.jpg

Then we set the same value in the x and y axis, both Avg:

Tutorial 5 bilde 3.jpg

The following graph should appear:

Tutorial 5 bilde 4.jpg

Not very informative, but we are not quite done yet :-)
Set the type back to Vertical again:

Tutorial 5 bilde 5.jpg

You may want to set the plot type to Bar again, and turn off markers:

Tutorial 5 bilde 6.jpg

Then we should have a nice graph, sorted by the value!

Tutorial 5 bilde 7.jpg


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).

Tutorial 5 bilde 8.JPG