Thank you, Jean, I shall try this this night/. /I hope that your answer
solves my question.
I shall also have to see how to control the colours so that they provide
a logical follow-up: for instance, from dark blue via yellow to to dark
read for very low to very high values.
- ftr
On 10/03/2015 18:10, Jean Bréfort wrote:
I fixed the issue in the git repository. Now, how matrix plots work? You
need to provide limits for the x values and y values, and a data matrix.
If the data matrix has n rows and m columns, you need m+1 x limits and n
+1 y limits. If you use labels, they will just label the limits, but the
implied values will be 1, 2, 3, and so on.
With the provided data, assuming that not at all is less than 25%, not
very much less that 50% etc…, you'll get a chart like the one attached.
Using unequally spaced values will give rectangles with different sizes.
Hope this helps.
Jean
Le mardi 10 mars 2015 à 08:05 +0100, Jean Bréfort a écrit :
Hi,
Select the cell range containing all your data and create the plot, that
should work. Row and column don't need to be numeric and the colors
should follow the numbers in the cells.
But, after testing, I don't get what I thought it would do. I need to
investigate a bit, feel free to file one ore more bug reports if you
find issues with this plot type.
Regards,
Jean
Le mardi 10 mars 2015 à 00:02 +0100, ftr a écrit :
Hi,
Can anyone help me please with the following data set that I want to
plot as a matrix plot or heat map ?
column variable:
not at all not very much
somewhat completely
not at all 428 49 10 2
not very much 1492 1407 135 14
somewhat 3115 7335 3138 101
completely 874 2668 3079 398
The maybe naive idea is that the color of the cells change with the
size of the cell count.
I post my question here as there is no indication in the help of how to
achieve this.
Maybe the values of the column and the row variables have to be numeric ?
TIA
ftr
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
