| Author |
 Topic  |
|
|
amethyste
Germany
23 Posts |
 Posted - 04/14/2023 : 07:43:49 AM
|
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
as the title says , i am trying to plot a heat map. the x axis and y axis are exactly what i want but the heat map is not showing the values i put there .
the values are just test values and i will add the real values later. any help with how i can fix it?
 |
|
|
snowli
USA
1379 Posts |
Posted - 04/14/2023 : 09:07:50 AM
|
All values are left-aligned which means the column is set as Text, instead of numbers.
Please double click column B header to open column properties db.
Set Format as Numeric or Text & Numeric.
There is an Apply to all columns to the right checkbox in the dialog.
Thanks, Snow |
 |
|
|
amethyste
Germany
23 Posts |
Posted - 04/18/2023 : 11:40:20 AM
|
Thank you so much for your help. This has worked perfectly.
Is there a way to make the color map scale as a text and numeric as well? So instead of Numbers, you'd have text |
|
|
|
snowli
USA
1379 Posts |
Posted - 04/18/2023 : 2:04:52 PM
|
U can put all text u want to show for each tick positions in the color scale.
E.g. put aa, bb, cc, .... in [Book1]Sheet1!F
Then double click the color scale to open Color Scale Control dialog.
Go to Labels tab.
Uncheck Auto under Display and choose Type: Tick Indexed Dataset.
Enter DatasetName as [Book1]Sheet1!F.
It will put aa, bb, cc at those tick locations in color scale.
Thanks, Snow
|
|
|
|
eliotbell1
1 Posts |
Posted - 04/27/2023 : 04:27:02 AM
|
| Thank you for discussion about it. It would be very helpful for me. |
|
|
|
amethyste
Germany
23 Posts |
Posted - 06/27/2023 : 07:51:21 AM
|
Is there a way to cross out one specific cell in the plot since it is not included in the calculation ? just have some type of pattern on it.
Also writing is a bit long so i would like to have a way to make it more visible? is there a way to format the x column texts? |
Edited by - amethyste on 06/27/2023 09:14:21 AM |
|
|
|
YimingChen
1593 Posts |
Posted - 06/27/2023 : 09:16:37 AM
|
What if you set the cell value to missing, see below:
James |
|
|
|
amethyste
Germany
23 Posts |
Posted - 06/27/2023 : 09:22:21 AM
|
that works but can it be a pattern rather than a color?
also can how can i make the cells in the plot more of a square ? mine are rectangles |
|
|
|
YimingChen
1593 Posts |
Posted - 06/27/2023 : 09:27:34 AM
|
Please double-click on the tick labels to open the axis properties dialog. Go to the Format subtab, you could choose to wrap the text.
James
quote:
Also writing is a bit long so i would like to have a way to make it more visible? is there a way to format the x column texts?
|
|
|
|
YimingChen
1593 Posts |
Posted - 06/27/2023 : 09:33:11 AM
|
To make the cell square, you can double-click on the graph to open Plot Details dialog, select Layer1 on the left panel, on the right go to the Size tab, and check the box Link Axis Length to Scale with X:Y Ratio.
Heatmap doesn't support pattern. As a workaround, you can use the Rectangle tool to draw a rectangle with pattern on top.
James
quote:
Originally posted by amethyste
that works but can it be a pattern rather than a color?
also can how can i make the cells in the plot more of a square ? mine are rectangles
|
|
|
|
amethyste
Germany
23 Posts |
Posted - 06/27/2023 : 10:07:53 AM
|
that makes it smaller actually . despite me changing the ratio to different things.
thank you so so much for your help |
|
|
| |
Topic |
|
heatmap issue