Re: heat map or matrix plot



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
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list


_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list

Attachment: matrix.png
Description: PNG image



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]