iworknumbers
In Excel, it's possible to display a "heatmap", i.e. colouring a group of cells depending on each cell's numeric value:
I'm looking to do the exact same thing in Numbers, but surprisingly I couldn't find how to do so. It seems like a very, very standard and reasonable feature to expect from a spreadsheet and I'd be very surprised if Numbers can't do it.
Is there any way to achieve this in Numbers?
Long text when Wrap text in cell is turned off does not merge with the next cell, it simply overlays on top of the adjacent cell if the adjacent cell is empty. Numbers just hides the borders for readability. If the adjacent cell has content, the text hides behind it.
There is no way, unfortunately, to expand the width of the cell to fit without expanding the width of the entire column.
Experiment with the text wrapping to get your desired result.
Hope this is useful!
Took me a while, but I figured it out: The solution is to choose a scatter plot instead of a line chart.
Select Insert -> Chart -> 2D Scatter
Select the chart, then select Add Chart Data:
Now simply select your entire table, including the x axis. Numbers will figure out the rest and automatically select your leftmost column as the x-axis.
Finally, to make it look like a line chart, select the chart, then select the "Axis" tab in the inspector Chose Data Symbols: None and Connection Lines: Straight.
Result:
Best Answer
Yes, you can do it in Numbers but it's not a simple command as far as I know. Your spreadsheet should have numbers in each cell and that represents the size and shape of your color map. Select your matrix and under the Format menu of Numbers, click on Conditional Highlighting. That gives you a pane that looks like so:
In the top right you see a button for Add a Rule. Click this button and set up your rules for your heat map. See next image.
I used only 4 colors but I just set up this quick example. You can have as many as you want, you just have to set the rules correctly. It the Add a rule your get a pane like shown below to select your rules.
I used the rule "Between two numbers" because it was easiest for this example...