Tutorial5

Fra mn/ifi/camsem
Revisjon per 1. jul. 2010 kl. 10:26 av Larsereb@uio.no (diskusjon | bidrag) (Ny side: '''How to sort data by value and keeping the original label''' <br>I want to sort my columns in accordance to their height, and not the label. How do I do that?<br>First I start of making t…)

(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 pot 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