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
